Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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:

=Sum({<Week_INF={">=$(=WeekStart(Max(Week_INF)-28))<=$(=Max(Week_INF))"}}>}CONTACS)

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?

Regards

Miguel del Valle

1 Reply
Highlighted

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