Displaying Change in a Pivot Table

[#1]

PFA the qlikview file.

here I want a column called "Change" as follows.  Change is basically calculated as Mar2013 -minus June 2013, Sep2013 minus June2013 and so on. Any help would be great.

Mar2013   Change   June2013  Change   Sep2013   Change Feb2014

600           900          1500          500         2000          -1000      1000

Thanks,

Ram

[its_anandrjs]

Any sequence of this month values

[its_anandrjs]

Hi check below script add another column PickCount for pick above value

A:

load * inline

[

PeriodCode, Count,

Feb2014    ,1000

Sep2013    ,2000

Jun2013     ,1500

Mar2013     ,600

];

LOAD

*,

Peek(Count) as PickCount

Resident A;

DROP Table A;

and in pivot table

Dimension : PeriodCode

Expression1 : Sum(Count)

Expression2 : sum(PickCount) - sum(Count)

Hope this helps

[#4]

No. I need a solution in the front end.

Sent from my iPhone

[its_anandrjs]

In straight table you can do like

Dim :- PeriodCode

Expression1 :- Sum(Count)

Expression2 :- Sum(Count) -Above(sum(Count))

Its is necessary that you use only Pivot table let me know.

Hope this helps

[mangalsk]

Hello ,

PFA

It gives following output:

[#7]

cannot afford do that in a script mate. Thanks anyway.

[#8]

thanks Anand. Yes, this has to be a Pivot table unfortunately.

[#9]

have you tried previous() ? i only used it in the script, but it might work in frontend expressions too.

f.e. in script

if(previous(item_ID)=[item_ID],

        DATA-previous(DATA),-1) as DATA_DIFF,

might work as

if(previous(item_ID)=[item_ID],

        DATA-previous(DATA),-1)

or even as

  DATA-previous(DATA)

but these kind of functions work better in the script - more performant anyway

[tresesco]

Doing it in the front-end would be a cumbersome work and a kind of static report (not recommended). Using straight table, create one expression for each monthyear like in attached sample.