Discussion board where members can get started with Qlik Sense.
I have a requirement. in my source file i have diff columns like below
SITE LIMIT 1 CONDITION
SITE LIMIT 1 VALUE
AGGR LIMIT 1 CONDITION
AGGR LIMIT 1 VALUE
here i have concatenated site and Agg value and condition
"SITE LIMIT 1 CONDITION" & "SITE LIMIT 1 VALUE" as Site_Red,
"AGGR LIMIT 1 CONDITION" & "AGGR LIMIT 1 VALUE" as Agg_Red,
but my actual req is i have below data
here i want to display Color based on ID here i want to display color as Red for Site_Red & Agg_Red columns.
if it is single value it should display site_red if is multiple values it should display Agg_red based on ID.
Pls help on this
Thnaks in Advance.