Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
tresesco, this is how it is now, a straight table with individual expressions. Once they load a data for more periods in the future, we have to go and modify the chart. which i think is not advisable. That is why i am looking for a viable solution. I basically want to pivot the period so that they appear in the column and be more dynamic. only think i am unable to achieve is the difference.
See attached a better option.
Hello ,
For expression level use following:
=fabs(sum(Count)- Above(sum((Count))))
No Mangal. Doesn't work in a Pivot table.
Hi,
Please find the attached file. Is it this what you what?
Thanks and Regards,
Jerry