Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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,

1 Solution

Accepted Solutions
sunny_talwar

See the updated qvw file

Capture.PNG

View solution in original post

9 Replies
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

];


Capture.PNG

Not applicable
Author

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

sunny_talwar

See the updated qvw file

Capture.PNG

Not applicable
Author

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

sunny_talwar

Here you go (Qlik Sense sample attached)

Capture.PNG

Not applicable
Author

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

Not applicable
Author

I got it to work, thanks

Not applicable
Author

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