topic Re: Help required for Pivot color coding in QlikView

Help required for Pivot color coding

piyush_s11 — Sat, 16 Nov 2024 03:59:09 GMT

Hi,

I have a pivot table in which different entities are there. For each entity I have to apply a fixed color code.

I have applied color code however it only applies to last column.

Please find attached screenshot for reference.

In above screenshot, you may find that, only for March month the color code is applying. I want the color code must be applied to all the month.

Also in Description section Retain & scrap I want to apply the same color code.

Please find attached qvw file for reference.

Kindly provide the solution.

Thanks in advance.

tresB — Tue, 02 Apr 2019 07:41:19 GMT

You have to use set analysis in background expression to ignore selections. Use expression like:

=Only({1}if(FieldID='400',RGB(0,255,0),if(FieldID='413',RGB(255,0,0),
if(FieldID='588',RGB(255,255,0),))))

avinashelite — Tue, 02 Apr 2019 08:39:36 GMT

This is because of the expression you have written and the single select option that you have enabled .....

you need to tweak the expression to make this work