topic Re: Select per trigger event in QlikView

Select per trigger event

Tue, 16 Dec 2014 09:58:13 GMT

Hi,

could you please help me with the attached sample?

I would like have the following:

Clicking on values in 'RAD Phase' sets the variable vRAD to 1 and selects 'RAD' in the field Sicht.

Deselecting all values in 'RAD Phase' sets the vRAD back to 0 and selects 'Standard'.

The same should be done for 'RAD Segment', so clicking on any value sets the variable to 1 and selects 'RAD', deselecting all set the variable to 0 and selects 'Standard'.

Thanks.

Re: Select per trigger event

saumyashah90 — Tue, 16 Dec 2014 10:10:04 GMT

Check this

Re: Select per trigger event

Tue, 16 Dec 2014 10:14:15 GMT

Okay, the variable is working for one of the two fields now, I can handle the other one. But what about the deselection of a RAD... value that shall select 'Standard'?

Many thanks.

Re: Select per trigger event

saumyashah90 — Tue, 16 Dec 2014 10:31:07 GMT

Sorry if i missed that..

This will help you

Re: Select per trigger event

saumyashah90 — Tue, 16 Dec 2014 10:44:13 GMT

Request you please mark it correct if you got your answer

Re: Select per trigger event

Wed, 17 Dec 2014 09:23:48 GMT

Thanks a lot, your solution is working fine and I will mark your answer as correct.

I have one issue, nevertheless. When I implement the solution into my real application, the "step back" does not work.

Meaning a phase and "RAD" are selected, I deselect the phase, then the variable is changing to 0, but the 'Sicht' is still 'RAD' and not 'Standard'. Do you have an idea what might be the issue? I compared everything several time from the demo to the application, but I don't see a difference.

Thanks!

Re: Select per trigger event

Wed, 17 Dec 2014 09:29:10 GMT

It seems that the OnChange event for the variable is not fired at all, as I added an action to lock a different field for testing purpose. This is not done, too.

Re: Select per trigger event

saumyashah90 — Wed, 17 Dec 2014 09:41:36 GMT

1)You should not lock any fields

2)check On Change trigger for the variable and also the definition of the variable

Re: Select per trigger event

Wed, 17 Dec 2014 09:53:53 GMT

1) Yeah, this is only to check if the onchange event trigger is fired.

2.) I put the change trigger expression into a textbox and it behaves as intended. This is the variable definition:

=if((GetSelectedCount([RAD_Phase.P])>0 or GetSelectedCount([RAD_Segment.P])>0) and Sicht='RAD' ,'1','0')

I only changed the field names accordingly to my application.

The onchange event only seems to fire when I still have a phase or segment selected and change 'Sicht' manually.

Re: Select per trigger event

saumyashah90 — Wed, 17 Dec 2014 10:00:37 GMT

It should work

Use this:

=if((GetSelectedCount([RAD_Phase.P])>0 or GetSelectedCount([RAD_Segment.P])>0),'1','0')

Re: Select per trigger event

Wed, 17 Dec 2014 10:04:33 GMT

No, it doesn't. It still doesn't jump back to Standard when I deselect the phase. The same works in your demo.qvw which confuses me.

Re: Select per trigger event

saumyashah90 — Wed, 17 Dec 2014 10:07:59 GMT

there would be something which you are missing.request you to check properly.

Re: Select per trigger event

saumyashah90 — Wed, 17 Dec 2014 10:10:16 GMT

Working for both PFA

Re: Select per trigger event

Wed, 17 Dec 2014 10:12:38 GMT

Ok, still not working. But this is not your fault, as the demo is working properly.

Re: Select per trigger event

saumyashah90 — Wed, 17 Dec 2014 10:14:51 GMT

Thanks Jens,

But still i have attached trigger for both.Check it once and let me know if its working for you?