Discussion Board for collaboration related to QlikView App Development.
Please help me here.
We Have two tables like below
I have a pivot table with Level(DrillDown Group) in Dimension and Value in Measure.
Background Color of the Measure should be from Table1 based Aggregated Value between From and To.
Note: The Color should change in runtime because the Aggregated value will change drill down to next level.
If there is no relation between your table , you can't directly give your range in the chart..
May be you can use the if condition in background expression.. Like
if(Value >0 and Value <=100, RGB(0,255,0))
Like wise other conditions..
Or in the backend , you can Aggregate your second Table,check your range using if condition, and create new color code field based on your range..