topic Automatically subdivide prices in QlikView https://community.qlik.com/t5/QlikView/Automatically-subdivide-prices/m-p/336177#M1170439 <HTML><HEAD></HEAD><BODY><P>Is there a possibility to automatically subdivide different prices of a product into 5 separate price ranges?</P><P>i.e. (highest price-lowest price)/5 = price difference --&gt; lowest price + price difference= first price range</P><P>Thanks for your help!</P></BODY></HTML> Thu, 05 Jul 2012 13:20:21 GMT 2012-07-05T13:20:21Z Automatically subdivide prices https://community.qlik.com/t5/QlikView/Automatically-subdivide-prices/m-p/336177#M1170439 <HTML><HEAD></HEAD><BODY><P>Is there a possibility to automatically subdivide different prices of a product into 5 separate price ranges?</P><P>i.e. (highest price-lowest price)/5 = price difference --&gt; lowest price + price difference= first price range</P><P>Thanks for your help!</P></BODY></HTML> Thu, 05 Jul 2012 13:20:21 GMT https://community.qlik.com/t5/QlikView/Automatically-subdivide-prices/m-p/336177#M1170439 2012-07-05T13:20:21Z Re: Automatically subdivide prices https://community.qlik.com/t5/QlikView/Automatically-subdivide-prices/m-p/336178#M1170440 <HTML><HEAD></HEAD><BODY><P>Should be possible by creating two variables for min and max price:</P><P>=min(PriceField)</P><P>=max(PriceField)</P><P></P><P>then using a calculated dimension:</P><P>=class(PriceField, (vMaxPrice-vMinPrice)/5 ,'x',vMinPrice)</P><P></P><P>and as expression what you like, e.g. count(distinct SupplierCompany)</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 05 Jul 2012 13:50:29 GMT https://community.qlik.com/t5/QlikView/Automatically-subdivide-prices/m-p/336178#M1170440 swuehl 2012-07-05T13:50:29Z