Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod2086
Contributor II

How to apply colors in single and Multiple values

Hi All,

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

  

IDCodeSITE LIMIT 1 CONDITIONSITE LIMIT 1 VALUEAGGR LIMIT 1 CONDITIONAGGR LIMIT 1 VALUE
5013W1>0>0
5009W2>50<0.8
5016W3>10<0.8
5015W4>95<0.8
5013W1<10>5
5013W1>=10>15
5009W2>0<0.8

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

stalwar1

reddys310

Thnaks in Advance.

Community Browser