topic Re: Calculate pivot table result based in previous value in QlikView

Calculate pivot table result based in previous value

Fernando_Sanchez — Thu, 24 Mar 2022 01:25:25 GMT

Hi all,

firt of all thanks a lot in advance for any future answer.

I am struggling quite a lo with obtaining a result within a pivot table based in previous value.

For example, I have this table:

Every month I have a certain decrease of a figure.

And what I am looking for is to obtain this output:

Where output is the rest of the inventory (in pct) available.

For example:

m01 value is 100% decreased by 1% --> 1* (1-0,01) --> 99.

m02 value is 99% decreased by 2% --> 0,99 * (1-0,02) --> 97,02.

m03 value is 97,02% decreased by 3% --> 0,9702* (1-0,03) --> 94,11.

And so on.

I have been playing with above, before and others, but i am not capable of finding the answer.

Thanlk a lot in advance!

Regards.

Fernando_Sanchez — Mon, 28 Mar 2022 09:35:54 GMT

Anybody?

I am sure this cannot be so hard, but I am really struggling.

Thanks a lot in advance.

Fernando_Sanchez — Thu, 31 Mar 2022 18:17:44 GMT

ok, I finally come up with the solution

The value for the second colum is

=if(month='m+00',1-pct,Alt(Above(output),0)-(pct*Alt(Above(output),0)))

Now. Once I have the value calculated, I want to put into a text box the first value to be above 50%.

But I am struggling to do so, as I do not have any clue about how "to extract" it from its pivot table.

Thanks a lot in advance.

Regards!