topic values in a list box in different format in QlikView

values in a list box in different format

rsdhavle — Mon, 26 May 2014 09:52:06 GMT

HI,

In a list box of application for current year i want to show value as '2014 April YTD' and other values i need to show only year so the values in a list box will values in a different format like '2014 April YTD', 2013, 2012, 2011, 2010....and so on. Is it possible if yes how to do that?

Re: values in a list box in different format

tresB — Mon, 26 May 2014 09:54:22 GMT

List box expression: =If(YearField=Year(today()), MonthName(today())&' YTD' , YearField)

Update: PFA

Re: values in a list box in different format

amit_saini — Mon, 26 May 2014 09:56:01 GMT

Hi Rohan,

Try this:

pick( WildMatch(Year,'*2014*','*2013*','*2012*'),'2014 April YTD','2013','2012')

Thanks,

Re: values in a list box in different format

Mon, 26 May 2014 09:56:49 GMT

If i get your question right, try this List Box Exp..

if(Year=Year(today()),Year(today())&' April YTD', Year)

Regards,

Prabhu

Re: values in a list box in different format

ashfaq_haseeb — Mon, 26 May 2014 10:07:27 GMT

Hi,

you can try something similar.

Regards

ASHFAQ