Normalisation, set area

[QlikWendy1]

Hi,

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.

Thanks

[dhasharadh]

Can you add some sample data.

[balabhaskarqlik]

In the measure, add an if condition to create different ranges of price, by that Price - Company can form into different buckets.

[ogautier62 · Accepted solution]

Hi,

here is an example :

replace Group by company

and avg(sales) by your formula for price-company

regards

[QlikWendy1]

Thanks a lot. It works perfectly!

Have a good weekend.

‌

[QlikWendy1]

‌Thank you!