Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Using FilterPane for Greater and Less than 1

See the updated qvw file

Capture.PNG

9 Replies
sunny_talwar
Not applicable

Re: Using FilterPane for Greater and Less than 1

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
Not applicable

Re: Using FilterPane for Greater and Less than 1

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

Re: Using FilterPane for Greater and Less than 1

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

sunny_talwar
Not applicable

Re: Using FilterPane for Greater and Less than 1

See the updated qvw file

Capture.PNG

Not applicable

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?Capture123.PNG

sunny_talwar
Not applicable

Re: Using FilterPane for Greater and Less than 1

Here you go (Qlik Sense sample attached)

Capture.PNG

Not applicable

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?

Not applicable

Re: Using FilterPane for Greater and Less than 1

I got it to work, thanks

Not applicable

Re: Using FilterPane for Greater and Less than 1

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