Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try expression like:
=Date((SubField(class(WeekID,13,'qtr',vModQtr),'< ',2)-2)*7+vMinDate)
where vMinDate==Min({1}Date#(WeekName,'MM/DD/YYYY'))
PFA
Try like:
SubField(class(WeekID,13,'Qtr',vModQtr),'< ',-1)
Hi Tresesco,
I tried this, but it gives me the WeekID. How do i get the WeekName ?
Thanks,
Diwakar
Try expression like:
=Date((SubField(class(WeekID,13,'qtr',vModQtr),'< ',2)-2)*7+vMinDate)
where vMinDate==Min({1}Date#(WeekName,'MM/DD/YYYY'))
PFA
Perfect!!! Thanks a ton..