topic Trying to plot a normal distribution in QlikView

Trying to plot a normal distribution

Tue, 03 Apr 2012 05:32:19 GMT

Hello,

I am trying to create a diagram showing the normal distribution of pallet weights in a machine.

The weight of the pallets, which carry coils with unique ID's, are calculated as the sum of the coil weights as shown below.

PalletID	CoilID	CoilWeight
1	1	100
1	2	50
2	3	200
1	4	90
3	5	100

In the example above, PalletID 1 has a total weight of 240 (100+50+90).

Now I would like to plot this table as a diagram with PalletWeight as X-axis and quantity as Y. Furthermore, I would like the X-axis to be presented as a couple of ranges; i.e. 0-50, 51-100, 101-150, 151-200 and so on.

When I use PalletID as dimension of a bar chart and Sum(CoilWeight) as the expression, I get the pallet weights over palletID's, but I have no idea of how to get the normal distribution over some ranges of weights.

Do you have an idea?

Thank you

Trying to plot a normal distribution

Anonymous — Wed, 04 Apr 2012 13:44:58 GMT

If I understand you correctly then one way you can get this is by using a caculated dimension

fe:

Calculated Dimension:

=IF (CoilWeight < 51 , '0 - 50' ,

IF (CoilWeight >= 51 and CoilWeight <= 100, '51-100',

IF (CoilWeight >= 101 and CoilWeight <= 150, '101-150',

IF (CoilWeight >= 151 and CoilWeight <= 200, '51-200',

'201 +'))))

Expression:

SUM(Quantity)

This calculated dimesion groups your Dimension.

Let me know if you get this to work, and if this is what you are looking for.

Good Luck,

Dennis.

Trying to plot a normal distribution

Tue, 08 May 2012 06:52:44 GMT

Thank you.