Discussion board where members can get started with QlikView.
Is there a possibility to automatically subdivide different prices of a product into 5 separate price ranges?
i.e. (highest price-lowest price)/5 = price difference --> lowest price + price difference= first price range
Thanks for your help!
Should be possible by creating two variables for min and max price:
then using a calculated dimension:
=class(PriceField, (vMaxPrice-vMinPrice)/5 ,'x',vMinPrice)
and as expression what you like, e.g. count(distinct SupplierCompany)