topic Re: Conditional Formatting - top two values in QlikView

Conditional Formatting - top two values

alisonpwallis — Wed, 28 Jan 2015 15:44:27 GMT

I have a chart where I need the top two percentages for each year to be highlighted (either by background colour or text, it doesn't matter). The data relates to particular categories and I want to know which categories have the highest percentage each time. I have tried conditional formatting the background colour and using visual cues but neither of them seem to work. I also don't know how to highlight the max value and the one below.

Can anyone help out?

I've attached a sample

thanks

Alison

Re: Conditional Formatting - top two values

morganaaron — Wed, 28 Jan 2015 15:57:53 GMT

Hi Alison,

Try inserting:

If(Rank(Count ({$ <[EffectiveTerm]={"201314","201213","201415"}>}[Current ID])/Count (TOTAL<[EffectiveTerm]>[Current ID]))<=2, LightGreen())

in the "Background Color" option for your expression. Swap out LightGreen() for whatever RGB() or Color() value you wanted.

Re: Conditional Formatting - top two values

alisonpwallis — Wed, 28 Jan 2015 16:23:11 GMT

That's great! Thank you so much.

Alison

Re: Conditional Formatting - top two values

Wed, 28 Jan 2015 16:25:07 GMT

Please find attached file.

Hope it helps you.