I have requirement where i need to achieve expressions dynamically,
HeatMap_Rules_Key | Condition | MinValue | MaxValue | Color |
1 | < | 0 | | Red |
2 | >= | 100 | | Blue |
3 | Between | 50 | 100 | Green |
4 | Between | 1 | 50 | Orange |
This table is a lookup table.
The values in the table can change (like different range and conditions and colour) but it will always have four rows.
The table explains what i need to show in heat maps.
If the value of the cell in a table i am displaying in the report is less than zero, then the cell containing the column should be red,
If it is between 50 and 100, it needs to be in green.
I am displaying values from another table in a table chart.
It looks like
ID | Sales | Product1 | Product2 | Product3 |
1 | Region1 | 0 | 50 | |
2 | Region2 | 100 | | |
3 | Region3 | 80 | 100 | |
4 | Region5 | 25 | 50 | 250 |
Is it possible to achieve this in qlikview?
