topic Re: Color coding in QlikView

Color coding

varunamin — Sat, 16 Nov 2024 17:54:43 GMT

Hi,

I am trying to color code values based on age. Using in Text Color within Pivot Table.

=if(max(Age) < 30, RGB(100,200,100),
if((max(Age) > 30 and max(Age) <= 60), RGB(51,51,255),
if(max(Age)> 60 AND ALT(Age,1), RGB(255,0,0)
)))

The above code only color codes few values and not all.

For instance, it color codes some values which are <30 and does not for few others. Please let me know if there is any other solution. Thanks!

Re: Color coding

Kushal_Chawda — Tue, 27 Oct 2020 23:03:57 GMT

@varunamin try to replace max(Age) with max(total Age)

Re: Color coding

varunamin — Wed, 28 Oct 2020 00:53:52 GMT

@Kushal_Chawda Tried but still not working.

Re: Color coding

Vegar — Wed, 28 Oct 2020 05:56:42 GMT

Have you tried adding the expressions max(Age) and ALT(Age,1) as measures into your pivot table in order to examine the output? Does these expressions provide the expected output?

Why are you using the ALT(Age,1) criteria? I would guess that all rows will return a numeric and therefore always be true in your if statement.

Re: Color coding

avinashelite — Wed, 28 Oct 2020 06:56:00 GMT

What's the dimension you using ? and will you able to share the sample file , so that we could check the issue

Re: Color coding

varunamin — Wed, 28 Oct 2020 22:20:03 GMT

@Vegar

Can remove the ALT() function as it won't make any difference . Was using it to exclude the null values in calculation.

Tried max(Age) in Expression and got the values as 0 for those where the color coding does not work. Those rows have valid data in them but still shows 0.

@avinashelite Using 3 dimensions and using the above code in one of the Text Color fields.

There is 1 Expression which counts the values. Sorry won't be able to share the data.

Thanks!