Sheet triggers?

Wed, 15 Jun 2011 11:28:55 GMT

Hi all,

I have two separate loads in my Qlikview document. Load1 data is displayed on 'Sheet 1' and Load2 data is displayed on 'Sheet 2'. When 'Sheet 2'

is activated i want to trigger code/or a macro that looks up a value in 'Sheet 1' (the user can change this selection as it a menu item) and compares it to a column in Load2, this will then define the data to diplay in 'Sheet 2'.

Does anyone know if this is possible?, i.e. can i trigger some form of logic when a sheet is loaded comparing two datasets which in turn modifies the values on the current sheet.

In relation to the logic, in simple form, i am trying to do the following;

If Load1.colour1= "Blue" then Load2.Colour2="Blue". I want this to filter to all the data on Sheet2.

I hope this makes sense,

thanks in advance,

cloggaireland

Re: Sheet triggers?

Wed, 15 Jun 2011 11:53:57 GMT

Yes, You can do this using the P() possible set functions comibed with -= notequal to

Check out the working example attached.

Re: Sheet triggers?

Wed, 15 Jun 2011 15:53:16 GMT

Thanks for that Sridhar, thats a great help, i also managed to do it using the sheet trigger and 'select in field' action (with an if statement).

thanks,

cloggaireland

topic Re: Sheet triggers? in QlikView

Sheet triggers?

Re: Sheet triggers?

Re: Sheet triggers?