Select in Field action in Qlik Sense button with less than \ greater than condition

[piotr-bratek]

Hi Guys,

I'm either suffering brain fog after a vaccination or sth is wrong 🙂
How can I filter <2 condition with Select in Field action using QS button  in such an easy example?

I mean what is the exact formula I should type in ?

[Quy_Nguyen · Accepted solution]

Hi, 

In the button  actions, please select "Select values matching search criteria", then select your Duration field, then in the Value box, type ='< 2'

Hope it helps.

[piotr-bratek]

Indeed, brain fog, thanks Buddy!

[morenoju]

How can I put an additional condition such as greater or equal than 1?
I've tried ='>=1 & <2' but it's taking only the second condition (<2).

[HilitDrori]

Hi,

I guess you solved it already, but if not, the syntax should be  ='>=1<2'