Filter on pricerange - Qlik Community

Anonymous · ‎2017-08-09

Hi,

I am trying to create a filter on a price range in purchaseprices.

So for example show only purchaseprices between 5,00 and 10,00.

Does anyone have a solution for this?

Anil_Babu_Samineni · ‎2017-08-09

May be you can use Advanced Search. Check in google related "Qlikview Types in Search"

>=500 <=1000

If it is in list box, Try this?

If(purchaseprices >= 500 and purchaseprices <= 100, purchaseprices)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-08-09

Create a Slider object

>> Field = Price

Mode= Multi Value

&

Value Mode = Continuous/Numeric

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2017-08-09

Check the attached sample

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2017-08-09

Thanks for your solutions. The slider is a nice one to remember.

No i solved it by adding

IF(PurchaPrice< 0.51, '0,00-0,50',

IF(PurchaPrice>=0.51 AND PurchaPrice<1.01, '0,51-1,00',

IF(PurchaPrice>=1.01 AND PurchaPrice<2.01, '1,01-2,00',

IF(PurchaPrice >=2.01 AND PurchaPrice<3.01, '2,01-3,00',))))

As PurchasePriceBetween

to my script and created a listbox to filter on it.