Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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