topic Previous Year Sum in QlikView

Previous Year Sum

Anonymous — Thu, 20 Jun 2013 16:13:46 GMT

I'm having trouble showing data for the previous year in a Pivot Table.

I have an expression:

sum([staff member])

with Dimensions:
Region, Dept, Period

and wanted to add another expression as:

sum(year={<year-1>} [staff members])

have tried many different options but none seems to work. I'm using a Pivot Table.

Gysbert_Wassenaar — Thu, 20 Jun 2013 16:24:12 GMT

Try: sum({<year={'$(=only(year)-1)'>} [staff members]).

Note, you can't also use year as a dimension in your pivot chart and you need to select one year.

Anonymous — Thu, 20 Jun 2013 16:34:45 GMT

This one is alsno not working.

Should I calculate totals in my script? Or should I change to another chart type from Pivot Chart ?

Anonymous — Thu, 20 Jun 2013 17:41:25 GMT

Any suggestions ?

subathra — Thu, 25 Aug 2016 07:16:32 GMT

Hi try this,

sum({<year={$(=Max(year)-1)}>}[staff members])