Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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