topic Re: How i make selectiosn always in list box in QlikView

How i make selectiosn always in list box

Mon, 22 Sep 2014 15:38:17 GMT

Hi All ,

I have created list box like 2010,2011,2012,2013,2014,2015,2016,2017.

but my requirement is i need to select always 2013,2014 always and need to hide other years.

Re: How i make selectiosn always in list box

Anonymous — Mon, 22 Sep 2014 15:40:21 GMT

define expression in listbox

if (youryear=2013 or youryear=2014, youryear)

Re: How i make selectiosn always in list box

tobias_klett — Mon, 22 Sep 2014 15:44:25 GMT

Hi sanjeev,
when you create the listbox go to the field dropdown and choose <Expression> instead of an field:

if(yearfield=2013 or yearfield=2014,yearfield)

Note: This only reduces the Display of the listbox.

If you want to select 2013 and 2014 permanently you can select them and rightclick on the listbox to lock the selection.

Re: How i make selectiosn always in list box

maxgro — Mon, 22 Sep 2014 23:49:57 GMT

or also (expression in listbox)

if(match(Year,'2014','2013'),Year)

Re: How i make selectiosn always in list box

Tue, 23 Sep 2014 09:27:37 GMT

it will show only 2013,2014 repeatdly how can i place only distinct for those years in same expression

Re: How i make selectiosn always in list box

Tue, 23 Sep 2014 09:28:56 GMT

it will show only 2013,2014 repeatdly how can i place only distinct for those years in same expression.becasue in feature also there may number of transations will comes for that it won't be select default in list box.

Re: How i make selectiosn always in list box

tobias_klett — Tue, 23 Sep 2014 09:44:45 GMT

Hi,

try this in your Chart expressions:

sum({<Yearfield={2013,2014}>} Valuefield)

Re: How i make selectiosn always in list box

maxgro — Tue, 23 Sep 2014 09:51:45 GMT

maybe

if(match(Year,'2014','2013'), year(Year))

Re: How i make selectiosn always in list box

amit_saini — Tue, 23 Sep 2014 09:55:22 GMT

Sanjeev,

Please see the attachment.

Thanks,