topic Re: Trigger on Value in QlikView

Trigger on Value

nihhalmca — Thu, 27 Jun 2013 11:04:35 GMT

Hi Experts,

Currently i am facing one query i.e

I need to give trigger on value for example

Dim: Product

But i need to give trigger only on 'a' and 'b'.(if i click 'a' i want to display another sheet)

I dont want to create trigger on 'c' and 'd'.

Please share your knowledge if you know

Thanks in Advance,

Nihhal.

Re: Trigger on Value

tresB — Thu, 27 Jun 2013 11:09:06 GMT

You have to make your sheet visibility conditional. Go to your sheet which one is to be made visible, right click on a blank space of the sheet->properties>General-> Show Sheet->Conditional

Now put there the condition - > Product= 'a' or Product = 'b'

Re: Trigger on Value

Thu, 27 Jun 2013 11:10:51 GMT

Hi,

PFA application

Regards,
Amay

Re: Trigger on Value

nihhalmca — Thu, 21 Nov 2013 09:19:30 GMT

Hi tresesco, sorry for late response

I tried it just it display sheet not activate sheet i am expecting if i click product 'a', sheet will be activated that sheet has related data and i am expecting field event trigger is it posible

Regards

Nihhal

Re: Trigger on Value

nihhalmca — Thu, 21 Nov 2013 09:32:58 GMT

Hi Amay Patil, Sorry for the late response

I have seen your application, it shows sheet not activated i am expecting if i click product 'a' sheet will be activated that sheet has related data and i am expecting field event trigger is it posible

Regards

Nihhal.

Re: Re: Trigger on Value

Thu, 21 Nov 2013 09:44:27 GMT

Hi Nihhal,

PFA.

I have modified the file provide by Amay Patil.

Hope it helps!

Edit: I have done it for one value 'A', you can use the similar trigger with if condition for 'B' as well.

Something like :

=If(Field = 'A','SH02',
If(Field = 'A','SH03'
))

Also, give this trigger OnSelect and OnChange both.

Re: Trigger on Value

spsrk_84 — Thu, 21 Nov 2013 10:50:17 GMT

Hi Nihhal,

Create an Field event trigger on both Select & Change as well .i.e Add Activate Sheet trigger using the below condition like for ex

IF (GETFIELDSELECTIONs(PRODUCT)='A','SH02','SH01')

Thanks,

Shiva

Re: Trigger on Value

nihhalmca — Thu, 27 Feb 2014 06:06:23 GMT

Thank You Shivaram Krishna.

NiHhal.