BoxPlot adding multiple measures .

[Qlikuser09]

i added only one measure to my box plot, however, is there a way I can add multiple measures to the chart so that the box plots are displayed separately

this is the measure I added

Sum({<[Product Name]>})[stationary]), I wanted to add more measures for a different product category Sum({<[Product Name]>})[Grocery ]), etc

.

[chrismarlow]

Hi,

Are your numeric amounts in fields called 'stationary' and 'Grocery' - or are they Product Names?

Looking at Box Plot you give it 3 things;

Dimensions

'Box' - this would be the thing that is aggregated over to do the min, max and percentiles etc, something like an order/customer number/ID

X-axis - so if your model had Product Name 'stationary' and 'Grocery' & amount in an amount field this could be it? Otherwise need to create an artificial dimension somehow ... it is possible

Measures

Y-axis - if stationary and Grocery are fields then as for X-axis will need to do something tricky - but if you have an amount field it could be as simple as Sum(Amount)

Cheers,

Chris. 

[Qlikuser09]

Hi I have my numeric fields in the stationary, Grocery etc and my Product Name is something like "ID"

[chrismarlow]

Hi,

If you can share some (made up) sample data that has same columns and 5 or 10 rows then I can share how it might work. If you can though it is probably worth remodelling your data to make Grocery/Stationary etc a product name dimension.

Cheers,

Chris.

[Qlikuser09]

this is my sample data :

Location Code	Eraser	Scale	Pen	Pencil	Sharpner
QWR	2	4	3	1	5
WER	1	5	3	6	6
RTY	3	6	5	7	4
FGH	4	4	6	8	3

[chrismarlow]

Hi,

On your load I would do a CrossTable, something like below;

CrossTable ([Product Type], [Amount], 1)
load * inline [
Location Code,	Eraser,	Scale,	Pen, Pencil, Sharpner
QWR,	2,	4,	3,	1,	5
WER,	1,	5,	3,	6,	6
RTY,	3,	6,	5,	7,	4
FGH,	4,	4,	6,	8,	3
];

The the box plot and (almost) anything else should be simpler.

Cheers,

Chris.