topic Re: Class Function Label in QlikView

Class Function Label

diwakarnahata — Mon, 20 Oct 2014 11:35:17 GMT

Hi All,

I have a class function which creates buckets of rolling 4 weekIDs (a sequence number). I want to label the bucket with the WeekName of the highest WeekID of the bucket. For e.g. In the below image, I want to show WeekName '04/05/2013' (of the highest WeekID of the bucket) instead of its bucket name '11 <= mth < 15'. How can I do that in QlikView?

I have used the the below expression to create buckets:

class(WeekID,13,'Qtr',vModQtr),'< ',2

Attached is the qvw for reference.

Thanks,

Diwakar

Re: Class Function Label

tresB — Mon, 20 Oct 2014 11:45:33 GMT

Try like:

SubField(class(WeekID,13,'Qtr',vModQtr),'< ',-1)

Re: Class Function Label

diwakarnahata — Mon, 20 Oct 2014 11:53:38 GMT

Hi Tresesco,

I tried this, but it gives me the WeekID. How do i get the WeekName ?

Thanks,

Diwakar

Re: Re: Class Function Label

tresB — Tue, 21 Oct 2014 05:50:46 GMT

Try expression like:

=Date((SubField(class(WeekID,13,'qtr',vModQtr),'< ',2)-2)*7+vMinDate)

where vMinDate==Min({1}Date#(WeekName,'MM/DD/YYYY'))

PFA

Re: Class Function Label

diwakarnahata — Wed, 22 Oct 2014 13:33:44 GMT

Perfect!!! Thanks a ton..