topic Re: How do i split 3 segment on a listbox into 3 different listbox in QlikView

How do i split 3 segment on a listbox into 3 different listbox

Anonymous — Wed, 13 Aug 2014 05:42:50 GMT

Plz find attached, it worked for yr, but how do i split day & month

Thanks

ashfaq_haseeb — Wed, 13 Aug 2014 06:03:49 GMT

Hi,

Even this 1 is corrupted.

Regards

ASHFAQ

Wed, 13 Aug 2014 09:25:43 GMT

Hi,

Please find the attached file, hope it solves your quest.

Alternatively, you can do the same in script

Wed, 13 Aug 2014 10:07:12 GMT

Hi,

I have attached this in previous reply also.

In case you did,t find that, here you go again (Main_Solution.qvw).

Thu, 14 Aug 2014 03:52:51 GMT

Hi,

For that, just replace the month expression by

=if(mid([Base Date - Base Date Level 01 (Text)],4,2)='01',dual('Jan',1),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='02',dual('Feb',2),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='03',dual('Mar',3),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='04',dual('Apr',4),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='05',dual('May',5),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='06',dual('Jun',6),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='07',dual('Jul',7),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='08',dual('Aug',8),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='09',dual('Sep',9),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='10',dual('Oct',10),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='11',dual('Nov',11),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='12',dual('Dec',12),

))))))))))))

Find the attached file.....