topic scripting/alternate state in QlikView

scripting/alternate state

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two filters, one in default state and other is in state1. is it possible to get same value selected in both the filters in different state based on some expression.

example :

Filter1: Source in default state

Filter 2: [Source 2] in state State1

if a user select some value in Source listbox which is in default state with some expression or trigger same value must be selected in Source 2 listbox which is in State1.

Thank in advance

-Priyanka

Re: scripting/alternate state

sunny_talwar — Mon, 25 Jul 2016 17:48:01 GMT

You should be able to use Trigger to select the same thing in the alternate state.

Re: scripting/alternate state

sunny_talwar — Mon, 25 Jul 2016 17:51:19 GMT

Check out the attachment

Re: scripting/alternate state

Mon, 25 Jul 2016 17:53:55 GMT

I could not find attachment

Re: scripting/alternate state

sunny_talwar — Mon, 25 Jul 2016 17:58:12 GMT

Open this link: Re: scripting/alternate state

Re: scripting/alternate state

Mon, 25 Jul 2016 20:23:38 GMT

‌Hi Sunny,

thankyou for your help . This is exactly what I want .

can you please tell me where and what trigger u have set to achieve this .

once again thanks a lot

Re: scripting/alternate state

sunny_talwar — Mon, 25 Jul 2016 20:37:15 GMT

Check the attachment

Re: scripting/alternate state

vishsaggi — Mon, 25 Jul 2016 20:41:23 GMT

Sunny Added the trigger from Document Properties -> Triggers Tab -> FieldEventTriggers highlighted

Re: scripting/alternate state

vishsaggi — Mon, 25 Jul 2016 20:42:42 GMT

Sorry Sunny did not see your update. 😉

Re: scripting/alternate state

sunny_talwar — Mon, 25 Jul 2016 20:44:14 GMT

No problem my friend

Re: scripting/alternate state

Tue, 26 Jul 2016 11:29:46 GMT

Hi Sunny,

i have implemented above solution and it is working fine for single word eg if filter1 has value "Book" it is working, but if it has value "Book Name" or "Book_Name" i.e. two words its not working

do you have any idea how to resolve it

Re: scripting/alternate state

sunny_talwar — Tue, 26 Jul 2016 11:51:45 GMT

Change the expression from

='(' & Concat(DISTINCT Chr(32) & Source & Chr(32), '|') & ')'

='(' & Concat(DISTINCT Chr(34) & Source & Chr(34), '|') & ')'

Re: scripting/alternate state

Tue, 26 Jul 2016 12:35:14 GMT

Thank you so much, it is working

Do you have some document(s) which i can refer to understand chr() function with different values

Thanks in advance

Re: scripting/alternate state

sunny_talwar — Tue, 26 Jul 2016 15:23:21 GMT

See if this helps?

ASCII and Binary Characters (The Characters)

How to find a number for a char: chr() and ord() functions‌http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/The_Characters.asp