Discussion board where members can get started with QlikView.
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.
Go to Solution.
here is an example :
replace Group by company
and avg(sales) by your formula for price-company
Can you add some sample data.
In the measure, add an if condition to create different ranges of price, by that Price - Company can form into different buckets.
Thanks a lot. It works perfectly!
Have a good weekend.