topic Re: Pivot Table - PYG expression in QlikView

Pivot Table - PYG expression

Wed, 28 Jan 2015 10:50:36 GMT

Hello,

I´m trying to create the PYG expression in a pivot table, but it shows the racio in the homologous month and the value in the current month.

This is the expression I used:

=Num(

( Sum(ProjectedSalesUnits)
-
Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits))
/
Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits)
,'#.##%')

Thanks!!!!

Re: Pivot Table - PYG expression

sunny_talwar — Wed, 28 Jan 2015 11:09:41 GMT

I am not sure I understand your question. What I can suggest is to break down your formula into pieces and check which piece is giving you potential issues. So I would create =Sum(ProjectedSalesUnits) as an expression and then Sum({$<Year=, Month=,YearMonth={"$(=Only(YearMonth)-100)"}>}ProjectedSalesUnits)) this as another expression and see if it is indeed showing value.

It might be more helpful if I can have some data to play with.

Best,

Re: Pivot Table - PYG expression

Wed, 28 Jan 2015 11:27:25 GMT

Thanks for your help!

I´ve done it before in a text object and the expression is correct.

The problem is that it shows the correct data on the totals, but it doesn´t in the selected month.

Here it goes another exemple.

Re: Pivot Table - PYG expression

sunny_talwar — Wed, 28 Jan 2015 12:05:43 GMT

I am not sure if you are trying to achieve this or not, but please check. PFA

Best,