Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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