topic Re: Re: Dynamic Title in QlikView

Dynamic Title

Anonymous — Thu, 19 Dec 2013 10:21:28 GMT

I have two fields: 'Week' which relates to calendar week number and 'WeekID' which relates to the company's financial reporting period week number. So...

'WeekID' 1 = 'Week' 19

'WeekID' 2 = 'Week' 20

'WeekID' 3 = 'Week' 21 etc to

'WeekID' 52 = 'Week' 18

When no weeks have been specifically selected the data shows the last week of the financial year (WeekID=52) which I have done, but I want the title to use the calendar week (Week=18)

Thanks

Re: Dynamic Title

Anonymous — Thu, 19 Dec 2013 10:25:44 GMT

As you would have considered Week Id in Expression then use Week in title to calculate the title.

May be I have not excatly got your question.

Please post a sample if possible.

Regards

Nitin

Re: Dynamic Title

Gysbert_Wassenaar — Thu, 19 Dec 2013 10:27:41 GMT

Something like ='Week ' & mod(WeekID+18,52)

Re: Dynamic Title

Anonymous — Thu, 19 Dec 2013 10:49:23 GMT

The data uses max(WeekID) so when no weeks are selected then it takes data for WeekID 52 which is the last week of the financial year which is correct. But if I use max(Week) or max(WeekID) in the title it shows 'Week 52' but I want it to show 'Week 18' which is the last CALENDAR week of the financial year

Re: Re: Dynamic Title

Anonymous — Thu, 19 Dec 2013 12:17:56 GMT

PFA,

Hope this helps.....

Regards

Nitin