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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dranjbar
Contributor III
Contributor III

Button - Select Values in a field - Multiple with a >

Id like to make a button which selects these "AR Days Band" which all have a < or > symbol inside them.

My usual approach is typing in the Value textbox. ='value1;value2;value3' which selects the 3 values with the button although i believe since the values have less than or greater than signs in them, it doesn't actually select anything.

I have included a screenshot below on what I am using as the Value as mentioned above (I've also tried some other things I have read in the forums but I cant find a solution to this). 

Is anyone able to help me with this? Thanks!

dranjbar_0-1605059478796.pngdranjbar_1-1605059674610.png

 

 

2 Replies
MayilVahanan

Hi @dranjbar 

Instead of using the symbol field, you can bring one num field & try like below


Load *, RowNo() as [AR Day Num] Inline
[
AR Day
<=65 Days
>70 Days
>=75 Days
80 Days
];

MayilVahanan_0-1605065854583.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dranjbar
Contributor III
Contributor III
Author

Unfortunately there isnt a AR Day Num field as the values are literally saved as "<75 days" etc (something like 70 days doesnt exist)