topic Setting default values in List box in QlikView

Setting default values in List box

Mon, 01 Jul 2013 10:14:14 GMT

HI All,

I have selction for five years 2009,2010,2011,2012,2013.How to set default view for only two years current and previous (2012,2013) in an List box selection.

Can you please help me ASAP.

Thanks,

Rahul

Re: Setting default values in List box

nizamsha — Mon, 01 Jul 2013 10:23:10 GMT

=Max(Year) & '-' &min(Year)-1

i thnk it will be useful

Re: Setting default values in List box

Mon, 01 Jul 2013 10:37:24 GMT

SET vMaxYear = Max(Year)

Load *

FROM$(SourceDir)Test.QVD
(qvd) Where Year > $(vMaxYear)-2;

Re: Setting default values in List box

Mon, 01 Jul 2013 10:59:08 GMT

Hi,

Choosse edit expression from drop down of field list of list box. In that you can write

if(Year=max(Year) or Year=(max(Year)-1),Year)

it will always take top two values always...

Hope it helps..

Re: Setting default values in List box

Mon, 01 Jul 2013 11:00:07 GMT

Hi,

Choosse edit expression from drop down of field list of list box. In that you can write

if(Year=max(Year) or Year=(max(Year)-1),Year)

it will always take top two values always...

Hope it helps..

Re: Setting default values in List box

Mon, 01 Jul 2013 11:43:34 GMT

Hi All,

Thanks for you responses. Actually, i am looking for this .Whenever I come to this sheet i want to Activate only for current year and previous year. If user wants he can select whatever he wants.

Re: Setting default values in List box

er_mohit — Mon, 01 Jul 2013 11:53:38 GMT

right clik on that sheet --->Go to trigger tab-->

add action on ActiveSheet-->click -->Add-->selection-->select in field

then put YearFiledname above and in search string write (2012|2013)

then ok

hope it helps

Re: Setting default values in List box

jagannalla — Mon, 01 Jul 2013 12:09:32 GMT

To work dynamically use this code.

='('&Year(Today())&'|' &(Year(Today())-1)&')'

Re: Setting default values in List box

ankitaag — Fri, 22 May 2015 09:19:46 GMT

and what if when User selects any other filter and then click Clear All, Then what will be the selection. Trigger will not fire because it's on Activate sheet.

Any suggestions?

Re: Setting default values in List box

Tue, 28 Jun 2016 12:34:37 GMT

Fantastic post... worked for me. Thanks

Re: Setting default values in List box

VBA_Master — Wed, 29 Jan 2020 12:41:59 GMT

This was very helpful. Thank you. D