Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikWendy1
Contributor
Contributor

Normalisation, set area

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

1 Solution

Accepted Solutions
ogautier62
Specialist II
Specialist II

Hi,

here is an example :

replace Group by company

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

regards

View solution in original post

5 Replies
dhasharadh
Creator III
Creator III

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
Specialist II
Specialist II

Hi,

here is an example :

replace Group by company

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

regards

QlikWendy1
Contributor
Contributor
Author

Thanks a lot. It works perfectly!

Have a good weekend.

QlikWendy1
Contributor
Contributor
Author

‌Thank you!