Using FilterPane for Greater and Less than 1

[#1]

Hello,

I am using the FilterPane in Qlik Sense Desktop and I currently have columns called Days and Price:

Days              Price

Monday           0.01

Tuesday          0.2

Wednesday     0.6

Thursday         1.15

Friday              1.2

Saturday          1.9

Sunday            0.9

Is there a way to have my Price columns show this instead of its actual values:

Price

Greater Than One

Less Than One

All I need is everything sorted out that if i choose the "Greater Than One" option, it will show:

Days          Price

Thursday     1.15

Friday          1.2

Saturday     1.9

Thank you,

[sunny_talwar]

You can do this in the script:

LOAD Days,

          Price,

          If(Price < 1, 'Less Than One', 'Greater Than One') as PriceFlag

FROM....

or you can use an expression for the list box

If(Price < 1, 'Less Than One', 'Greater Than One')

[sunny_talwar]

Sample script:

Table:

LOAD *,

  If(Price < 1, 'Less Than One', 'Greater Than One') as PriceFlag;

LOAD * INLINE [

    Days,              Price

    Monday,          0.01

    Tuesday,          0.2

    Wednesday,    0.6

    Thursday,        1.15

    Friday,            1.2

    Saturday,          1.9

    Sunday,            0.9

];

[#4]

I can't seem to edit it on the FilterPane, it's saying "Invalid Dimension"

[sunny_talwar · Accepted solution]

See the updated qvw file

[#6]

I am using Qlik Sense Desktop, I am not able to open the file you uploaded. Where should I enter the formula?

[sunny_talwar]

Here you go (Qlik Sense sample attached)

[#8]

Thank you. And did you do Add Dimension? Where did you put the actual equation? Through Data or Sorting?

[#9]

I got it to work, thanks

[#10]

please advise how can i filder from -1 to +1 in some dimension..