Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
migueldelval
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
sunny_talwar

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