Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Rolling 13 Months show only values of last week

Hi all,

I have contacts for each week. And I show this information in a mini graph, but only last 5 weeks. I use this expression:


But Now I need to make a other graph what Dimension it´s Month, and I need to show the Contacs information for the last 13 months.

But for each month I only might to show the value of the last week.

Its a little bit strange but it´s my requirement.

Can somebody help me?


Miguel del Valle

1 Reply

May be create a flag in the script for the last 7 days of every month in the script and then use that to calculate what you might be looking for