Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

piyush_s11
Contributor

Help required for Pivot color coding

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.

image9.PNG

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.

2 Solutions

Accepted Solutions
Highlighted
MVP
MVP

Re: Help required for Pivot color coding

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),))))

Capture.PNG

Re: Help required for Pivot color coding

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 

 

2 Replies
Highlighted
MVP
MVP

Re: Help required for Pivot color coding

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),))))

Capture.PNG

Re: Help required for Pivot color coding

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