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: 
Anonymous
Not applicable

continuous selection

Hi

In my application there are fields where the end user must be prohibeted to make a discontinuous selection.

If such a field is a dual field or contains numbers it can be done by applying a trigger action on select like:

='>=' & min(FieldName) & '<=' & max(FieldName)


But the difficulty if that my field is of a text type and I don't want to turn it into a dual field. It means that I cannot apply an action like: ='>=' & min(FieldName) & '<=' & max(FieldName)


Is it somehow possible to select from min to max in a text Field based on a FieldIndex? For example: from minimal FieldIndex to maximal Field Index?


Thank you in advance,


Larisa

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

You need to create the compound search embedding the field values in double quotes when they contain e.g. spaces:

=CONCAT({1} chr(34)&FieldValue('FIELD',ValueLoop(vMinFV,vMaxFV) )&chr(34),'|')

View solution in original post

5 Replies
swuehl
Champion III
Champion III

maybe like attached?

Anonymous
Not applicable
Author

Thank you!

Anonymous
Not applicable
Author

Hi Swuel,

As soon as I renamed the field values, it stopped working. Could you please have a look?

Thank you in advance,

Larisa

swuehl
Champion III
Champion III

You need to create the compound search embedding the field values in double quotes when they contain e.g. spaces:

=CONCAT({1} chr(34)&FieldValue('FIELD',ValueLoop(vMinFV,vMaxFV) )&chr(34),'|')

Anonymous
Not applicable
Author

Thanks a lot!