topic Re: Triggers How to Select 2 values in the same field QV11 in QlikView

Triggers How to Select 2 values in the same field QV11

Fri, 15 Mar 2013 17:20:01 GMT

I have a field called LOAN CATEGORY CALL REPORT, the field has several products. I would like to set a sheet trigger to select both 'Indirect Auto' and 'Direct Auto' when the tab is selected. I can set it to open with one field selected, but not the additional field. I'm certain it is probably syntax error, but I'm really frustrated. Any help would be greatly appreciated!

This works:

OnActivateSheet>Select In Field:

Field > [LOAN CATEGORY CALL REPORT]

Search String > ='Indirect Auto'

This DOES NOT Work:

OnActivateSheet>Select In Field:

Field > [LOAN CATEGORY CALL REPORT]

Search String > = [LOAN CATEGORY CALL REPORT] = 'Indirect Auto' and [LOAN CATEGORY CALL REPORT] = 'Direct Auto'

Re: Triggers How to Select 2 values in the same field QV11

Fri, 15 Mar 2013 17:42:28 GMT

("Indirect Auto"|"Direct Auto")

Re: Triggers How to Select 2 values in the same field QV11

sibin_jacob — Sun, 17 Mar 2013 15:19:55 GMT

='(Indirect*Auto|Direct*Auto)'

Re: Triggers How to Select 2 values in the same field QV11

Mon, 18 Mar 2013 14:55:49 GMT

Great! Thank you Sibin, this works. I'm wondering why though, is it basically doing a wild card search or with triggers do you have to use the asterisk for spaces in field values?

Re: Triggers How to Select 2 values in the same field QV11

sibin_jacob — Mon, 18 Mar 2013 16:04:23 GMT

If you are using trigger for select in field, you need to replace space with asterrisk.

If your string not containg space no need to use asterrisk.

Thanks,

Sibin Jacob.C

Re: Triggers How to Select 2 values in the same field QV11

Wed, 22 May 2013 11:15:45 GMT

Hi,

I've just come across this answer as I was having a similar problem.

My problem, however, is that in my field I have "Strongly agree" / "Strongly disagree" / "Agree"

and only want to have Strongly agree / Agree selected.

Using ='(Strongly*agree|Agree)' also selects "Strongly disagree" as the asterix acts as a wildcard in this instance.

I am using the Select in Field action. Could you possible help?

Cheers,

Re: Triggers How to Select 2 values in the same field QV11

Wed, 22 May 2013 15:09:04 GMT

I’m sorry, but I have not solved this one yet. If you come across the answer, I’d appreciate it if you could post it to this thread!

Thanks!

Re: Triggers How to Select 2 values in the same field QV11

Wed, 22 May 2013 15:10:39 GMT

Did you try using the double quotes as I suggested? That removes the need for a wildcard.

Re: Triggers How to Select 2 values in the same field QV11

Wed, 22 May 2013 15:20:02 GMT

Ah just seen properly, had thought I'd already tried that.

Yes, Rebecca is correct. If i use

("Strongly agree"|"Agree")

as my search it does indeed work.

Thankyou!