Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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.