Assign a value <=150000 to a variable with a button

[licciardello]

Hello,

I need to select all values less than or equal to a number in a file. The number is inserted into a variable using an input field. For this I use a button, which selects the value in the field with this script:

= '<= $ (Variable name)'

If I do the same thing in QlikView it works, but in Qlik Sense it doesn't work.

What am I doing wrong?

[paweln]

Hi

I did the same some time ago to check if I have some old products in the warehouse.

Variable Input where user can define number of days ( vNoOfDays ). Then I display list of products that stay in the warehouse longer than this in the table. 

I belive you need at least one measure.

Max({"=Today()-Date([Warehouse Incoming date])"={">$(vNoOfDays)"}>} [ProductWeight])

[licciardello · Accepted solution]

Found.

Maybe I didn't know, but the import script behaves differently between View and Sense. Basically what was imported as a number in View is imported as text in Sense.

I had to force the load by indicating Num (fieldXXX) and so it worked