Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
anya
Contributor III
Contributor III

Calendar

 

Haloo,

the issue that I'm experiencing right now is about how to process dates or autocalendar in qlik sense. I have data with the format date 1/10/2020, item name and sales. how to take the amount of sales from the month ago or  6 month's  ago, or year ago 

 

Thanks 

1 Reply
lorenzoconforti
Specialist II
Specialist II

If you are trying to resolve this in your visualization, then use something like this:

sum({<Date = {'>=$(=addmonths(today(),-6))'}>} sales)