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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make dimension show prev month dates

Hi All,

how do i create a calculated dimension for dates to show for prev month if we on current  max month

each month it must roll back by a full prev month.

or in the Expression if possible also, if maybe we want to sum sales.

e.g

Dates
2015/09/30
2015/09/28
2015/08/12
2015/08/06
2015/08/04
2015/07/17

output should be:

Dates
2015/08/12
2015/08/06
2015/08/04
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If(Dates<MonthStart(today()) and Dates>=MonthStart(today(),-1),Dates)


talk is cheap, supply exceeds demand