topic Re: Sum vs Previous Sum By Years, % in QlikView

Sum vs Previous Sum By Years, %

Death4Free — Thu, 27 Sep 2018 07:02:50 GMT

Hi! How can I calculate measure in pivot table - Sales Vs Prev. sales, % ( there could be more years, and i have Calendar Master if it helps)?

felipedl — Thu, 27 Sep 2018 11:38:03 GMT

Hi Aleksandrs,

loading as an example the data you posted, like so:

oad * Inline

[

Month,Year,Sales

dec,2016,10

dec,2017,12

dec,2018,10

jan,2016,9

jan,2017,6

jan,2018,8

feb,2016,15

feb,2017,16

feb,2018,18

];

You can get it by using the before statement: before(sum(Sales)).

What it does, on a pivot table, is to get the previous (left) value.

Using the expression, I got:

See the attached QVW for example and further expressions that I added.

Death4Free — Fri, 28 Sep 2018 05:10:23 GMT

Thank you for help