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

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

Mon, 16 Mar 2015 06:06:29 GMT

Hi All,

I have one field as Country with below field values

Country

All

India

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

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

rwunderlich — Mon, 16 Mar 2015 06:37:13 GMT

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

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

Mon, 16 Mar 2015 07:01:03 GMT

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.

Can you please advice!

Thanks,

Raju

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

sasikanth — Mon, 16 Mar 2015 07:17:44 GMT

simply you can use * in search string

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

rwunderlich — Mon, 16 Mar 2015 07:19:09 GMT

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

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

Mon, 16 Mar 2015 07:47:05 GMT

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

Raju

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

Mon, 16 Mar 2015 07:48:31 GMT

* is not working! solution got by ROB!

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

rwunderlich — Mon, 16 Mar 2015 13:38:01 GMT

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

-Rob

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

Mon, 16 Mar 2015 15:58:30 GMT

Sure Rob!

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

Tue, 24 Mar 2015 09:07:43 GMT

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

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

rwunderlich — Tue, 24 Mar 2015 10:40:51 GMT

You will need double quotes around the values. Try:

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

,'*'

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

)

-Rob

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

Tue, 24 Mar 2015 11:48:21 GMT

Rob, Its working! Thanks a ton!

Raju

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

pratap6699 — Mon, 13 Apr 2015 04:39:09 GMT

very nice post sir,,,i have same requirement like this,,,,that is now we are select 'All' fieldvalue in country field then all fieldvalues will be selected right,,,now my requirment is when you select 'ALL' all selections will be clear like 'clearall button' is it possible...

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

rwunderlich — Mon, 13 Apr 2015 17:39:18 GMT

Just select a value that isn't there. That should clear the field.

-Rob