Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can anyone help me to implement one trigger on below scenario?

Hi All,

I have one field as Country with below field values

Country

All

India

uk

hongkong

china

brazil

Now i want to implement trigger on field value " All " to "select all" the field values in country field?

So that i can view the complete data related all countries.

Thanks in advance!

Raju

Tags (1)
1 Solution

Accepted Solutions

Re: Can anyone help me to implement one trigger on below scenario?

Use Action Select in Field on field: Country

Search String:

=if(SubStringCount(GetFieldSelections(Country),'All')>0

,'*'

,'(' &  GetFieldSelections(Country,'|') & ')'

)

-Rob

http://masterssummit.com

http://robwunderlich.com

13 Replies

Re: Can anyone help me to implement one trigger on below scenario?

Use Action Select in Field on field: Country

Search String:

=if(SubStringCount(GetFieldSelections(Country),'All')>0

,'*'

,'(' &  GetFieldSelections(Country,'|') & ')'

)

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable

Re: Can anyone help me to implement one trigger on below scenario?

Hi Rob!!

Thanks for quick response!

I implement as you said, but i am unable to get the result? Can you please see the attachments.

Trigger.PNG

Result.PNG

Can you please advice!

Thanks,

Raju

sasikanth
Valued Contributor III

Re: Can anyone help me to implement one trigger on below scenario?

simply you can use * in search string

Re: Can anyone help me to implement one trigger on below scenario?

In the expression, I think you need to specify all as "ALL" to match the case of your value. If you have further questions, can you post a qvw?

-Rob

Not applicable

Re: Can anyone help me to implement one trigger on below scenario?

You are great troubleshooter!! Thank you very much it is working!!!

Raju

Not applicable

Re: Can anyone help me to implement one trigger on below scenario?

* is not working! solution got by ROB!

Re: Can anyone help me to implement one trigger on below scenario?

Glad it's working. Please mark something as correct to close the thread.

-Rob

Not applicable

Re: Can anyone help me to implement one trigger on below scenario?

Sure Rob!

Not applicable

Re: Can anyone help me to implement one trigger on below scenario?

Hi Rob,

Greetings!

We found one bug after using the

=if(SubStringCount(GetFieldSelections(Country),'All')>0

,'*'

,'(' &  GetFieldSelections(Country,'|') & ')'

)

in trigger.

Now we are unable to find the data related to particular country names (two string countries) in listbox

Hong Kong

United Arab Emirates

United Kingdom

But we are getting correct values for one string countries like india, us, austaila.

Can you please advice me to get the data related to two string countries also?

Thanks,

Raju

Community Browser