topic Re: Filter on pricerange in QlikView

Filter on pricerange

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 09 Aug 2017 13:03:43 GMT

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)

vinieme12 — Wed, 09 Aug 2017 13:22:28 GMT

Create a Slider object

>> Field = Price

Mode= Multi Value

Value Mode = Continuous/Numeric

vinieme12 — Wed, 09 Aug 2017 13:25:58 GMT

Check the attached sample

Anonymous — Wed, 09 Aug 2017 14:41:46 GMT

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.