Achieving conditions dynamically

[naveenchellaara]

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?

[phaneendra_kunc]

is this example didn't worked?

http://community.qlik.com/message/314814#314814

[naveenchellaara]

No it dint work.. i want to select the operators dynamically.