Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot Expression - Get Value from Lookup Table

Please help me here.

We Have two tables like below

Table1.

FromToColorCode
0100RGB(0,255,0)
101500RGB(255,251,122)
501999RGB(0,255,0)

Table2.

MetricIDDrillDownGroupvalue
1L150
2L150
1L245
2L245
1L360
3L360

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.

LevelValue
L1100
L290
L3120

Note: The Color should change in runtime because the Aggregated value will change drill down to next level.

1 Reply
Highlighted

Hi,

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..