Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

13 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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
Master
Master

simply you can use * in search string

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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

Raju

Not applicable
Author

* is not working! solution got by ROB!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Not applicable
Author

Sure Rob!

Not applicable
Author

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