Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
onetwothree123
Partner - Contributor III
Partner - Contributor III

List box Expression picking up extra value

I have following expression in my list box and it's giving me a extra value as wk.

 

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week

Not able to figure out how to get rid off it.

See attachemnt for Listbox and expression.

2 Replies
swarup_malli
Specialist
Specialist

AJ,

Try this,

if(len(MMMYY_Week)>=8,

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week))

or  

if(len(

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week)) >=8,

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week))

Regards

Swarup

onetwothree123
Partner - Contributor III
Partner - Contributor III
Author

Thanks Swarup