topic Re: Showing specific dates in labels in QlikView

Showing specific dates in labels

Fri, 13 Sep 2013 11:35:45 GMT

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.

Re: Showing specific dates in labels

Fri, 13 Sep 2013 11:37:52 GMT

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

Re: Showing specific dates in labels

sujeetsingh — Fri, 13 Sep 2013 11:38:57 GMT

Why dont you give a Sample .

Re: Showing specific dates in labels

Fri, 13 Sep 2013 11:53:04 GMT

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?