topic Re: Conditional trigger Select field in QlikView

Conditional trigger Select field

simondachstr — Mon, 06 Aug 2012 10:03:19 GMT

Hello everyone,

I have a hard time finding a solution to the following challenge:

There is a variable called vselection.

While vselection has the value 1, I want an automatic trigger on Field 1, which selects the same values in Field 2. Something like a synchronisation.

When the variable is on 0, the synchronisation should be turned off, thus selections in Field 1 don't affect selections in Field 2 anymore.

Idea 1:

The code should look something like this:

Trigger in Field 1

Select Field

Field:

=if(vselection=1, [Field 2])

Selection:

='=sum({<[Field 2]=[Field 1]>}1)'

Unfortunality though, QlikView does not support conditional statements in the Field section which means that the above code is not working.

Idea 2:

Trigger in Field 1

Select Field

Field:

[Field 2]

Selection

=if(vselection=1,'=sum({<[Field 2]=[Field 1]>}1)')

This works fine while vselection has the value 1. Once it's 0 though, the trigger clears Field 2 which is not desirable. I want to keep the selections in Field 2.

Your help is appreciated

Sincerely,

Martin

Re: Conditional trigger Select field

Anonymous — Mon, 06 Aug 2012 10:25:01 GMT

Martin,

I didn't try this but hope it works:
Action is selection in flield.
Field is Field2.
Search string is: =if(vSelection=1, <value of Field1>, <value of Field2>).

If it doesn't work, the oly alternative is to use macro, I think.

Regards,
Michael

Re: Conditional trigger Select field

simondachstr — Mon, 06 Aug 2012 11:28:46 GMT

Thank you for your reply, Michael.

I actually tried this aswell but I didn't manage to work it out. The problem was how to syntax that the trigger should select the already selected Values in Field 2.

Luckily, I found a working solution using alternate states:

Copy selection in <Standart> state to an alternate state, if vselection=1 is selected.

Make all necessary selection with "Select Field" Trigger.

If vselection=1, copy back alternate state 1 to <Standart>.