topic Re: Select more values on Activation Sheet in QlikView

Select more values on Activation Sheet

Sat, 01 Dec 2012 10:40:02 GMT

Hi,

what is the syntax to select more fileds on activation sheet.

I can select only one value. I would like when I clik on my sheet1 the values A,R,S,T is selected.

Thanks for your help.

Judi.

Re: Select more values on Activation Sheet

Gysbert_Wassenaar — Sat, 01 Dec 2012 10:42:22 GMT

This is the search string you need: (A|R|S|T)

The values are enclosed between parentheses and are separated by a pipe symbol '|'

Re: Select more values on Activation Sheet

Sat, 01 Dec 2012 11:57:55 GMT

Thanks. It's true pipe symbol '|'.

I have an other question : In my input box I try to change operator '=' by '<='

Inmy presentation tab is it possible to show or not the operator but how can I change '=' to '<=' ?

An idea ?

Thanks for your help.

Re: Select more values on Activation Sheet

Gysbert_Wassenaar — Sat, 01 Dec 2012 12:45:12 GMT

No, that's not possible. The alternative is to use a variables, one for the operator and one for the value to compare to. Create an input box for the two variables. The variables can then be concatenated to create a search string for the field. See attached example.

Re: Select more values on Activation Sheet

Sat, 01 Dec 2012 14:13:37 GMT

Thanks for your help, Gysbert.