topic Re: List box selected fields to be shown in QlikView

List box selected fields to be shown

Anonymous — Mon, 09 Feb 2015 05:50:51 GMT

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

Re: List box selected fields to be shown

tresB — Mon, 09 Feb 2015 05:54:28 GMT

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

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

Re: List box selected fields to be shown

AbhijitBansode — Mon, 09 Feb 2015 05:58:06 GMT

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.

Re: List box selected fields to be shown

Anonymous — Mon, 09 Feb 2015 06:13:08 GMT

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

Re: List box selected fields to be shown

PrashantSangle — Mon, 09 Feb 2015 06:16:38 GMT

Hi,

Try like

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

If possible post your sample app.

Regards

Re: List box selected fields to be shown

tresB — Mon, 09 Feb 2015 06:17:05 GMT

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

Re: List box selected fields to be shown

jagan — Mon, 09 Feb 2015 06:27:06 GMT

Hi,

Try like this

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

Regards,

Jagan.

Re: List box selected fields to be shown

vinay_hg — Mon, 09 Feb 2015 06:43:34 GMT

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.