How to create a chart with auto created series?
Scenario: you have this bar chart in QlikView. The straight table for it is this one, with one column for type, one for date, and one for number. You cannot use series to create that chart in BIReport, since you do not have a column for each type. ...
How to set a dynamically image form a QlikView table?
Scenario: In a QlikView table, each item is associated to an image inside the disk. How to replicate this dynamic association inside BIReport? Solution: add a Picture Box to the report and while it is selected, open the Script Editor and select the ...
How to create a multi-column report?
Scenario: the desired output is like this: a multicolumn output from a straight table in QlikView™ Solution: create a multicolumn layout for the detail band. Click on the little arrow on the detail band header, while the band is selected. In the ...
How to add an index?
From the toolbox, drag and drop the tool Table of Contents in the Report Header. Open the Table of contents tasks window clicking on the little arrow on the top right of the object, click on the ellipsis and Add a new level. Set the appearance and ...
How to conditionally colour a chart?
Scenario: In a bar chart, you want each bar colour depending on its value. Solution: Add the chart to the Report, and with the chart selected go to scripts. Add the following script: // Apply different colors to the bars depending on their value ...