Creating filters in qlik sense for pivot table

[nishanthi_8]

I have a pivot table where I indicated the some margin values to be given in some colors. This is measure in my case. But I need to create filters for the pivot table explicitly within particular range say for example <25 to be red color like that. Is that possible?

[Gysbert_Wassenaar]

Yes, that's possible. You can specify that you want to use an expression to calculate the background color of the column. You'll need an expression like:

If( ...value... < 0.25, LightRed(), if( ...value... < 0.75, RGB(255,128,0). LightGreen() ))

Change ...value... with the field or expression that calculates the values you see as percentages in the column.

[nishanthi_8]

ya this I got. But unlike Bar chart can i create legend like for pivot table using some other options available?

[#4]

Hi,

You can describe coloring logic using Footnote property of pivot object - this is simple idea but pretty logical. You will find footnote in properties of pivot object under Apperance -> General -> Footnote. Example below.

BR,

Milosz