Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

To Show Rolling 3 Months Data

Hi All,

I want to show rolling 3 months sales in straight table based on month selection.

For Eg. If I select June from filter then data should show June, May, April months sales value

I have only year and month field in the data. I don't have date field.

Please help to achieve this task.

Thanks

1 Reply
rubenmarin

Hi, one possible solution may be using an as-of calendar: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130