9 Replies Latest reply: Oct 24, 2016 3:25 AM by Mukesh Chanalya

# Using FilterPane for Greater and Less than 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,

• ###### Re: Using FilterPane for Greater and Less than 1

You can do this in the script:

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')

• ###### Re: Using FilterPane for Greater and Less than 1

Sample script:

Table:

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

Days,              Price

Monday,          0.01

Tuesday,          0.2

Wednesday,    0.6

Thursday,        1.15

Friday,            1.2

Saturday,          1.9

Sunday,            0.9

];

• ###### Re: Using FilterPane for Greater and Less than 1

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

• ###### Re: Using FilterPane for Greater and Less than 1

See the updated qvw file

• ###### Re: Using FilterPane for Greater and Less than 1

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

• ###### Re: Using FilterPane for Greater and Less than 1

Here you go (Qlik Sense sample attached)

• ###### Re: Using FilterPane for Greater and Less than 1

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

• ###### Re: Using FilterPane for Greater and Less than 1

I got it to work, thanks

• ###### Re: Using FilterPane for Greater and Less than 1

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