Showing specific dates in labels - Qlik Community

Report Inappropriate Content · ‎2013-09-13

Hello,

I have a requirement to show previous 4 weeks of data and applicable week ending dates as labels.

So in the script, I have Current Week = 1 gives Week End= 15/09/13, Prior Week = 1 gives Week End = 08/09/13 and so on and obviously this will change through the calendar week

I wish to display the relevant date in the label of each table as the weeks go on.

Any ideas?

Thanks.

Report Inappropriate Content · ‎2013-09-13

Could you be a little more specific? E.g. an example of what the table should look like given certain selections.

sujeetsingh · ‎2013-09-13

Why dont you give a Sample .

Report Inappropriate Content · ‎2013-09-13

So I have a table that shows data based on set analysis.

And in the set analysis expressions, the date criteria is PriorWeek = , giving the value of 15/09/2013)

In my Calendar script, I have the following if that helps

inweek(PK_CALENDAR,'$(vToday)',0,0)*-1 as _CurrentWeek, ( gives WeekEnd date of 15/09/2013

inweek(PK_CALENDAR,'$(vToday)',-1,0)*-1 as _PriorWeek, ( gives 08/09/2013

inweek(PK_CALENDAR,'$(vToday)',-2,0)*-1 as _PriorPriorWeek (gives 01/09/2013)

It’s the WeekEnd date I want to appear in the label expression?