topic Re: Pivot Table Formatting in QlikView

Pivot Table Formatting

evansabres — Tue, 23 Feb 2016 16:08:36 GMT

Hello -

I have a pivot table that shows available tickets for different sections of an arena. My chart appears as this:

I want to have the cells formatted, similar to a heat map. Is this possible? I would like to have the cell appear purple if more than 100 tickets remaining and orange if less than 100.

Thank you.

Re: Pivot Table Formatting

sunny_talwar — Tue, 23 Feb 2016 16:10:39 GMT

If you should be able to use background color expression to do this:

If(YourExpression > 100, RGBforPurple, RGBforOrange)

Re: Pivot Table Formatting

evansabres — Tue, 23 Feb 2016 16:20:12 GMT

thank you

Re: Pivot Table Formatting

rubenmarin — Tue, 23 Feb 2016 16:29:56 GMT

Hi, I also use:

If(ExpressionLabel> 100, RGBforPurple, RGBforOrange)

This way if the expression changes the backgroundcolor will apply the modified expression without requiring any changes (althought it needs manually maintenance if expression label changes)

Not sure if this uses the already calculated value (wich should give better performance) or recalculates the expression.