Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set expression for dates of a month from previous year

Hi,

I
need to create a calculated dimension to get dates of a month from
previous year. I will be using this as oppose to current date (
4/5/2014):

Date(of a month from last year)
Total Sales
4/1/2013100252.00
.
.
4/30/201390548.00

To note - I have date two variables to get the start date of a month and end date of a month from last year.

Need help with suggestion on how this can be done with set expression.

2 Replies
Gysbert_Wassenaar

Don't use a calculated dimension. Just use your date field as dimension and a set analysis expression that limits the records to those of the requested period: sum({<Date={">=$(vStartDate)<=$(vEndDate)"}>}Sales).


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks, Gysbert - this was helpful; appreciate your suggestion.