topic Re: Macro in QlikView

Macro

Wed, 18 Jul 2012 20:30:13 GMT

Hi,

I'm looking for a macro : when I select a year it selects selected year and the previous year.

Any idea is appreciated.

Thanks,

Re: Macro

rwunderlich — Wed, 18 Jul 2012 21:12:34 GMT

Don't us a macro. Use a OnSelect Action for the field (Set in Document Properties Triggers pane).

Use Toggle Select as the action.

For the field value use

=only(Year)-1

-Rob

Re: Macro

Thu, 19 Jul 2012 13:22:40 GMT

Thanks Rob,

But I want to select the selected year and previous year at the same time.With Toggle select , it selects only one at a time.

Thanks

Re: Macro

MayilVahanan — Thu, 19 Jul 2012 13:32:58 GMT

Hi,

Try like this,

Document properties ->Triggers ->Field in event trigger -> Year

OnSelect ->Action->Select in field

Field ->Year

SearchString-> ='(*'&vT1&'*|*'&vT&'*)'

Where vT1 => Max(Year) and vT => Max(Year)-1

Hope it helps

Re: Macro

Thu, 19 Jul 2012 13:50:04 GMT

Sorry , it only selects the max(year)-1 ....

Thanks

Re: Macro

MayilVahanan — Thu, 19 Jul 2012 14:01:02 GMT

hi,

For me, it work correctly.. Can you post a file?

Re: Macro

Thu, 19 Jul 2012 14:06:14 GMT

My mistake, I used toggle select....

Thanks again..

Re: Macro

rwunderlich — Thu, 19 Jul 2012 14:16:25 GMT

...But I want to select the selected year and previous year at the same time.With Toggle select , it selects only one at a time....

When I test with V11, it retains the selection I make and the Toggle Selection adds the prior year. I get both years selected.

-Rob

Re: Macro

Fri, 20 Jul 2012 13:20:24 GMT

Here is another problem now!

Let say if I want to select 2 years like 2008 and 2010 , how can I manage it?

Thanks

Re: Macro

MayilVahanan — Fri, 20 Jul 2012 13:37:16 GMT

Hi,

OnSelect ->Action->Select in field

Field ->Year

SearchString-> ='(*'&vT1&'*|*'&vT&'*)'

Where vT1 => Max(Year) and vT => Max(Year)-2

Do you want to select 2008 and 2010 only,

='(*2008 | 2010*)'

Hope it helps

Re: Macro

Fri, 20 Jul 2012 13:41:36 GMT

Hi,

I want to make it dynamic means: if the user selects one year for example 2010 them it shows 2010 & 2009 but if the selects 2010 and 2008 then it shows these 2 years not any thing else.

Do you think if this is possible?

Thanks,

Re: Macro

MayilVahanan — Fri, 20 Jul 2012 14:13:44 GMT

HI,

Try like this,

=if(GetSelectedCount(Year) > 1, '(*'&vT1&'*|*'&vT&'*)','(*'&vT1&'*|*'&vT&'*|*'&vT2&'*|*'&vT3&'*)')

But it helps for two year selection only..

Where vT1 => Max(Year) and vT => Max(Year)-1, vT2 => Min(Year) and vT3 =>Min(Year)-1

Re: Macro

Fri, 20 Jul 2012 17:34:39 GMT

I changed it to this and worked for me , thanks

=if(GetSelectedCount(YEAR) = 1, '(*'&vT1&'*|*'&vT&'*)',

if(GetSelectedCount(YEAR) > 1, '(*'&vT1&'*|*'&vT3&'*)',vT1))

Re: Macro

Mon, 23 Jul 2012 13:49:23 GMT

Hi Mayil,

I have another request for you Mayil,

If we want to this action just for certain pages how we can do that?

Thanks,

Nima

Re: Macro

MayilVahanan — Mon, 23 Jul 2012 13:58:50 GMT

Hi,

If you use qlikview -11 , use alternate state for certain page ..sheet->properties->alternate state..

But make sure, no change affect in that sheet..For more info about alternat state, please refer qlikview manual or help..

Hope it helps..

Re: Macro

Mon, 23 Jul 2012 14:09:30 GMT

I'm in qlik -11 but I don't have this option.

Thanks,

Re: Macro

MayilVahanan — Mon, 23 Jul 2012 14:13:20 GMT

Hi,

Setting->Document properites->general->alternate state..

Add alternate state in that. Then you use it in sheet properties->general.

Hope it helps

Re: Macro

Mon, 23 Jul 2012 14:46:14 GMT

Sorry Mayil,

But it works for every selection , I just need it to be done on only one slection like "year".

Thanks,

Re: Macro

MayilVahanan — Mon, 23 Jul 2012 14:56:59 GMT

Hi,

Actually, you want to select a year , in one sheet. but no reflection on another sheet ?? but want to reflect in same page for year.

donot want to change any reflect in all page when select the year field and no reflect in the same page also means, you can set alternate state for that particular field ..without alternate state, inspite of my knowledge i dono how to exclude selection in all page..

If you want for it and also for understand the alternate state, please refer the following page

http://community.qlik.com/message/240621#240621

Re: Macro

Mon, 23 Jul 2012 15:09:51 GMT

Thanks for reply,

The only thing I want is to make the trigger we created for the year, works on certain page not all the pages . And it seems it's not doable???