topic Re: Pivot table with calculation year to year in QlikView

Pivot table with calculation year to year

vchuprina — Fri, 13 Jan 2017 08:39:23 GMT

Hi,

I'm trying to create pivot table with following structure, but can't correctly calculate Evolution.

In my model I have weight and height and based on it I calculate index as Heigth/Weigth.

Evolution should be counted by comparing current year with previous (2017 vs 2016, 2016 vs 2015, 2015 vs 2014)

Can someone help with set expression.

sunny_talwar — Fri, 13 Jan 2017 12:31:54 GMT

Is Weight and Height part of a single dimension or are they dimensions itself? Would you be able to share raw data behind this to help you better?

vchuprina — Fri, 13 Jan 2017 13:40:00 GMT

Weight and Height are dimensions itself

sunny_talwar — Fri, 13 Jan 2017 13:45:27 GMT

Would you be able to share sample data or a sample qvw file?

vchuprina — Mon, 16 Jan 2017 09:24:08 GMT

Hi Sunny,

Please find sample qvw in attachment

ahaahaaha — Mon, 16 Jan 2017 12:18:06 GMT

What exactly is compared when calculating the Evolution ? You can give an example of the calculation of Evolution for at least one year?

sunny_talwar — Mon, 16 Jan 2017 15:02:57 GMT

Try this:

=((Weight/Height)/Before(Weight/Height) - 1) * 100

vchuprina — Mon, 16 Jan 2017 15:28:42 GMT

Thank you. I didn't know about before function

sunny_talwar — Tue, 17 Jan 2017 01:53:38 GMT

You can check out after and before here: