topic Help wirh getting previous month in QlikView

Help wirh getting previous month

Mon, 23 Jun 2014 16:30:22 GMT

I have a pivot table where I am showing the last 4 months of data. Like this:

Month Count Previous Change

Jun-2014 42,115 63,227 -21,112

May-2014 63,227 59,126 4,101
April-2014 59,126 58,595 531

Mar-2014 58,595 - -

I am currently using Below(column(1)) to determine the amount in the 'Previous' column.

However, using this method presents an issue on determining the 'Previous' for 'Mar-2014' since the previous month 'Feb=2014' is not being displayed in the chart.

Is there a way to use set analysis and change the way 'Previous' is calculated so that I can get that earliest month in the chart?

Re: Help wirh getting previous month

Anonymous — Mon, 23 Jun 2014 16:40:20 GMT

why not use the same expression that you use for "Count" with set analysis to find the previous month? something like below:

insert correct field names and modify expression for your requirement.

count ({<Month={"=addmonths(/*Date*/,-1)"}>} /*ID*/)

Re: Help wirh getting previous month

Mon, 23 Jun 2014 16:49:21 GMT

Thanks jsaradhi. I think this might work, but what would the date field look like in (/*Date*/ date field you have listed. Can you walk me through what I would change it to?

Re: Help wirh getting previous month

Mon, 23 Jun 2014 17:01:17 GMT

Tried this

(DISTINCT{<Month={"=addmonths(Max([Event Date]),-1)"}>}Event.User)

but gave me the current count and not the previous. What am I doing wrong?

Re: Help wirh getting previous month

Mon, 23 Jun 2014 20:07:32 GMT

I saw you replied but it did not come through