How i make selectiosn always in list box

[#1]

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.

[Anonymous]

define expression in listbox

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

[tobias_klett]

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.

[maxgro]

or also (expression in listbox)

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

[#5]

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

[#6]

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.

[tobias_klett]

Hi,

try this in your Chart expressions:

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

[maxgro]

maybe

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

[amit_saini]

Sanjeev,

Please see the attachment.

Thanks,

AS