topic Re: help with alternate state trigger in QlikView

help with alternate state trigger

hopkinsc — Wed, 24 Jun 2015 14:13:59 GMT

hi all,

i have an on activate sheet trigger which takes the selections from a list box on sheet 1 and applys it to a list box on sheet 2.

both sheets are in different alternate states.

The trigger only seems to work if 1 value is selcted, if i select multiple values then nothing is passed to the other list box.

Does anyone know how i can get this to work for any value selected? apart from when there is nothing selected, i dont want anything passed if nothing is selected.

i have attached an example.

Thanks in advanced

Re: help with alternate state trigger

ramoncova06 — Wed, 24 Jun 2015 14:34:43 GMT

try by adding this to your trigger

='(' & Concat(DISTINCT [Dim 1], '|') & ')'

Re: help with alternate state trigger

hopkinsc — Wed, 24 Jun 2015 14:49:10 GMT

Hi, thanks, that works for multiple selections, but when there's no selections made it carries all possible selections over instead. i don't want it to do that.

I have tried adding an if statement to the trigger but i cant seem to get the state to work within the if statement.

i have added a text box with the getselectedcount of the field in state2 but it seems to only pick up the default state..

see updated example attached.

Re: help with alternate state trigger

Anonymous — Wed, 24 Jun 2015 14:59:28 GMT

Try something like this for your GetSelectedCount() for your State2 :

=GetSelectedCount ( [Dim 1] , 0 , 'State2' )

Re: help with alternate state trigger

hopkinsc — Wed, 24 Jun 2015 15:05:10 GMT

i am getting an error in expression error.

am i right in thinking that the 3rd paramter of getselectedcount is only available in 11.2SR8 and above?

i am on SR5 and the client that this is for is on SR4.

I don't think they will upgrade just to get this working..

Re: help with alternate state trigger

Anonymous — Wed, 24 Jun 2015 15:13:14 GMT

Unfortunately I think you are correct, as in did come out post SR5.

Re: help with alternate state trigger

ramoncova06 — Wed, 24 Jun 2015 15:27:33 GMT

see if this works for you

I switched the trigger to document side instead of sheet

Re: help with alternate state trigger

hopkinsc — Wed, 24 Jun 2015 15:52:00 GMT

Hi, thanks, that seems to work. i have already changed my approach though and i have gone through each object and told each expression to ignore certain fields instead of using alternate states .

thanks

Re: help with alternate state trigger

ramoncova06 — Wed, 24 Jun 2015 15:53:16 GMT

Glad it worked

Re: help with alternate state trigger

ecolomer — Wed, 24 Jun 2015 15:57:22 GMT

Here you have an example