List box selected fields to be shown - Qlik Community

Anonymous · ‎2015-02-09

Here in this list box i want to display only 2012,2013,2014 only .how can i ?

tresesco · ‎2015-02-09

Instead of taking the field directly in the list box, use an expression like:

=If(Match(YearField, 2012,2013, 2014), YearField)

AbhijitBansode · ‎2015-02-09

Do you want to do analysis over these 3 years only?

If so, then load data of only these 3 years. this way you can optimize your application by reducing its size.

Anonymous · ‎2015-02-09

i have already used this expression but it is showing the same .

PrashantSangle · ‎2015-02-09

Hi,

Try like

If(wildmatch(YearField,'*2012*','*2013*','*2014*'),YearField).

If possible post your sample app.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

tresesco · ‎2015-02-09

Perhaps there is some issue specific to your data. Try to share your sample data.

jagan · ‎2015-02-09

Hi,

Try like this

=Aggr(If(Match(YearField, 2012,2013, 2014), YearField), YearField)

Regards,

Jagan.

vinay_hg · ‎2015-02-09

hi

try to load the data only to related 3 years as ur requirement if you want analyse only 3 year data. it will reduce the size & app also will be faster.