Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
sfysfy313
New 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
Valued Contributor II

Re: Normalisation, set area

Hi,

here is an example :

replace Group by company

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

regards

5 Replies
dhasharadh
Contributor II

Re: Normalisation, set area

Can you add some sample data.

balabhaskarqlik
Honored Contributor

Re: Normalisation, set area

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

ogautier62
Valued Contributor II

Re: Normalisation, set area

Hi,

here is an example :

replace Group by company

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

regards

sfysfy313
New Contributor

Re: Normalisation, set area

Thanks a lot. It works perfectly!

Have a good weekend.

sfysfy313
New Contributor

Re: Normalisation, set area

‌Thank you!