Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Automatically subdivide prices

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!

1 Reply
MVP
MVP

Re: Automatically subdivide prices

Should be possible by creating two variables for min and max price:

=min(PriceField)

=max(PriceField)

then using a calculated dimension:

=class(PriceField, (vMaxPrice-vMinPrice)/5 ,'x',vMinPrice)

and as expression what you like, e.g. count(distinct SupplierCompany)

Regards,

Stefan

Community Browser