Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.