Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Pico
Partner - Creator
Partner - Creator

Select values in a field sintax

Greeting everyone!

 

I cannot find the sintax for the "select values in a field" action in a sheet.

I have the field "InvoiceMonth" and the values are 202201, 202202,202203 etc...

I would like to select only the first three month, I tried A LOT  of combinations, both with semicolon ad not (this is the only hint I found in the documentation here).

Thank you so much for the help

have a nice day!

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Choose "Toggle Field Selection"  instead of "Select values in field" and try below with single quotes

 

='(202201|202202|202203)'

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

Try as below

(202201|202202|202203)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Pico
Partner - Creator
Partner - Creator
Author

This error message appears:

Error in expression: ')' expected.

 

Both starting with and without '='

vinieme12
Champion III
Champion III

Choose "Toggle Field Selection"  instead of "Select values in field" and try below with single quotes

 

='(202201|202202|202203)'

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.