topic Re: How to use button to select year_ = 2012 ? in QlikView

How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 12:46:00 GMT

Hi All

May i know how to use the button to select year_ =2012 ?

=num(Year(Today()) -1)

I try above not able to work. any work around ?

Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 12:50:11 GMT

Create A button

goto Actions -> Selection -> Select in field -> Year- Search string(2012)

hope it helps..

Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 12:52:26 GMT

Hi Paul,

Check the attached QVW.

you need to use Right function to get it Selected.

Thanks,

Shruthi

Re: Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 13:05:16 GMT

Hi sir

you code seen to work , but i need the year selected turn green. can you advise me how to make it turn green ?

Re: Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 13:06:19 GMT

Hi sir

I need the code that is selection of current year for this year and next year when press the button.

Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 13:08:18 GMT

Hi Paul,

you can check the attached QVW in my previous reply.

Since the Year is the listbox is showing oly 2 digits its not selceting.

so if use Right function, it selects and turns green.Hope this solves. similary for current year and next year.

Thanks,

Shruthi

Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 13:16:06 GMT

Hi shru

yes i aware your qv doc send me turn green.

But In my actual qv application , i need to make some change of the list box. i need to add :-

=If(Year>1995, year_)

Check my latest doc pls.

Re: How to use button to select year_ = 2012 ?

Thu, 28 Nov 2013 13:36:23 GMT

Hi Paul,

You are using a listbox with a calculated dimension, check current selections and you'll see that your action button makes a selection in the year_ listbox.

Fredrik