Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

Thanks

4 Replies
tresesco
MVP
MVP

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
Champion III
Champion III

Hi Zion,

Have a look at the attached application.

Regards

ASHFAQ

tresesco
MVP
MVP

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
Champion III
Champion III

Hi,

Have a look at my attachment

Regards

ASHFAQ