topic Re: Normalisation, set area in QlikView https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137089#M765747 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. It works perfectly!</P><P>Have a good weekend.</P><P>‌</P></BODY></HTML> Fri, 13 Jul 2018 16:00:32 GMT QlikWendy1 2018-07-13T16:00:32Z Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137085#M765743 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am struggling with normalising data. I have some data of prices wrt different companies. I want to rescale the data so that the area between the price-company line and the x-axis(companies) is 1.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137085#M765743 QlikWendy1 2020-11-25T16:16:04Z Re: Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137086#M765744 <HTML><HEAD></HEAD><BODY><P>Can you add some sample data.</P></BODY></HTML> Thu, 12 Jul 2018 17:26:37 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137086#M765744 dhasharadh 2018-07-12T17:26:37Z Re: Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137087#M765745 <HTML><HEAD></HEAD><BODY><P>In the measure, add an if condition to create different ranges of price, by that Price - Company can form into different buckets.</P></BODY></HTML> Fri, 13 Jul 2018 09:52:25 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137087#M765745 BalaBhaskar_Qlik 2018-07-13T09:52:25Z Re: Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137088#M765746 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>here is an example :</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207791_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>replace Group by company</P><P>and avg(sales) by your formula for price-company</P><P></P><P>regards</P></BODY></HTML> Fri, 13 Jul 2018 10:02:52 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137088#M765746 ogautier62 2018-07-13T10:02:52Z Re: Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137089#M765747 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. It works perfectly!</P><P>Have a good weekend.</P><P>‌</P></BODY></HTML> Fri, 13 Jul 2018 16:00:32 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137089#M765747 QlikWendy1 2018-07-13T16:00:32Z Re: Normalisation, set area https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137090#M765748 <HTML><HEAD></HEAD><BODY><P>‌Thank you!</P></BODY></HTML> Fri, 13 Jul 2018 16:01:27 GMT https://community.qlik.com/t5/QlikView/Normalisation-set-area/m-p/137090#M765748 QlikWendy1 2018-07-13T16:01:27Z