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

    Using FilterPane for Greater and Less than 1

    Roy Morales

      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,