topic Re: Comparing values in Pivot Table in QlikView

Comparing values in Pivot Table

k_burata — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a pivot table shown below in which I need to compare value between actual and budget. What should happen is that on the Actual Row it should shade it with Red to indicate that Actual is > Budget.

Background Color Expression:

If([Type] = 'ACTUAL' and Sum({<Type={'ACTUAL'}>}Value) > Sum({<Type={'BUDGET'}>}Value), Red())

Can somebody point me into the right direction?

Cheers,

Re: Comparing values in Pivot Table

sunny_talwar — Fri, 26 Aug 2016 09:15:37 GMT

Try this may be:

If([Stat] = 'ACTUAL' and Sum(TOTAL <Type> {<Stat={'ACTUAL'}>}Value) > Sum(TOTAL <Type> {<Stat={'BUDGET'}>}Value), Red())

Re: Comparing values in Pivot Table

k_burata — Mon, 29 Aug 2016 04:02:18 GMT

Hi Sunny,

Thanks for the reply.

It is working but when I add a few more data then the formula suddenly breaks.

Do I need some more modifiers?

Regards

Re: Comparing values in Pivot Table

sunny_talwar — Mon, 29 Aug 2016 09:41:17 GMT

How about now?

If([Stat] = 'ACTUAL' and Sum(TOTAL <Type, Position, Title> {<Stat={'ACTUAL'}>}Value) > Sum(TOTAL <Type, Position, Title> {<Stat={'BUDGET'}>}Value), Red())