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 08:48:13 GMT

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

Thanks

tresB — Wed, 13 Aug 2014 09:07:25 GMT

Day(list box expression) : =Aggr(Day(Date#(Left(C.Base,11), 'DD MMM YYYY')),C.Base)

Month(list box expression) : =Aggr(Month(Date#(Left(C.Base,11), 'DD MMM YYYY')),C.Base)

ashfaq_haseeb — Wed, 13 Aug 2014 09:20:47 GMT

Hi Zion,

Have a look at the attached application.

Regards

ASHFAQ

tresB — Wed, 13 Aug 2014 09:56:43 GMT

Just remove the Aggr from the expression part and try like:

Day(Date#(Left(C.Base,11), 'DD MMM YYYY')) as Day

Month(Date#(Left(C.Base,11), 'DD MMM YYYY')) as Month

ashfaq_haseeb — Wed, 13 Aug 2014 09:56:46 GMT

Hi,

Have a look at my attachment

Regards

ASHFAQ