topic Re: Conditional color for Calculated dimension in QlikView

Conditional color for Calculated dimension

joshibabu_are — Thu, 30 Mar 2017 10:49:13 GMT

Hi All,

i have Calculated Dimension like Below:

=Num(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket),'#,##0.00%')

i want to show Conditional color based on above dimension.

Example:

If (Compliance %) is <=90 Red

>=91 and <=94 Yellow

95 and above Green

I have tried below expression but not working.

=if(num(Aggr(sum(aggr(Count(DISTINCT{<Status={Ontime}>}Employee_Number),[Updated Location],Region_Name,Site_Name, Status,Complaince_Training_Program, MonthBucket))/
Sum(Aggr(Count(DISTINCT Employee_Number),[Updated Location],Region_Name,Site_Name, Status,Complaince_Training_Program, MonthBucket)), MonthBucket),'##,#0%') <=90,RGB(255,0,0),Yellow())

How to achieve in Calculated Dimension,

Any Help would be greatly appreciated.

Thanks

Joshi

Re: Conditional color for Calculated dimension

sunny_talwar — Thu, 30 Mar 2017 15:25:13 GMT

May be try this

If(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket) <= 0.90, RGB(255,0,0),

If(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket) <= 0.94, Yellow(), Green()))

Re: Conditional color for Calculated dimension

joshibabu_are — Thu, 30 Mar 2017 15:41:44 GMT

Hi Sunny,

No Luck only else part showing Green Color.

Thanks,

Re: Conditional color for Calculated dimension

sunny_talwar — Thu, 30 Mar 2017 15:43:30 GMT

Can you try this?

If(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)) <= 0.90, RGB(255,0,0),

If(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)) <= 0.94, Yellow(), Green()))

Re: Conditional color for Calculated dimension

joshibabu_are — Fri, 31 Mar 2017 11:35:47 GMT

Hi Sunny,

Still no Luck

Thanks,

joshi

Re: Conditional color for Calculated dimension

sunny_talwar — Fri, 31 Mar 2017 11:38:06 GMT

Would you be able to share a sample?