Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis Previous Month

Hi

Could someone give me an example of how to get the previous month's data only in set analysis for PK_Date.

I am currently using the below as a dimension, which returns previous month (then I suppress Null).

I know it would be better to make it an expression.Any help appreciated.  My dimension formula is:

MonthName(MonthStart(Today())-1)=(MonthName(PK_Date)),(MonthName(PK_Date))

How do I make it a set analysis? or is there a better way?

n.b.  PK_Date is month level only

Cheers

Phil

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<PK_Date = {"=MonthName(PK_Date) = MonthName(Today(), -1)"}>}Measure)

View solution in original post

2 Replies
sunny_talwar

May be this

Sum({<PK_Date = {"=MonthName(PK_Date) = MonthName(Today(), -1)"}>}Measure)

Anonymous
Not applicable
Author

Thanks