topic Re: List box Expression picking up extra value in QlikView

List box Expression picking up extra value

onetwothree123 — Thu, 27 Jun 2013 14:48:28 GMT

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.

swarup_malli — Thu, 27 Jun 2013 14:52:56 GMT

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))

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 — Thu, 27 Jun 2013 14:56:27 GMT

Thanks Swarup