Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
define expression in listbox
if (youryear=2013 or youryear=2014, youryear)
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.
or also (expression in listbox)
if(match(Year,'2014','2013'),Year)
it will show only 2013,2014 repeatdly how can i place only distinct for those years in same expression
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.
Hi,
try this in your Chart expressions:
sum({<Yearfield={2013,2014}>} Valuefield)
maybe
if(match(Year,'2014','2013'), year(Year))
Sanjeev,
Please see the attachment.
Thanks,
AS