topic Re: Box Plot- 2,3 datasets in QlikView

Box Plot- 2,3 datasets

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to create a box plot with serveral datasets:

- discharge simulated

- discharge measured

- discharge simualted_2

The aim is to easily see the difference between the datasets.

I can't find out how to make this i Qklikview.

Anyone who knows?

Re: Box Plot- 2,3 datasets

Anil_Babu_Samineni — Wed, 12 Oct 2016 16:28:02 GMT

You can create Mekko Chart / Block Chart to achieve this

Re: Box Plot- 2,3 datasets

Thu, 13 Oct 2016 07:59:29 GMT

I can't see how a Mekko Chart is equal to a box plot chart.

Re: Box Plot- 2,3 datasets

Anil_Babu_Samineni — Fri, 14 Oct 2016 01:56:59 GMT

I mean you can use those Two for showing the box..

Re: Box Plot- 2,3 datasets

jonathandienst — Fri, 14 Oct 2016 05:17:21 GMT

Select a combo chart, enter the main expression, clear the line/bar/symbol options. The box plot option should now be available. When you check that, the expression is converted to the box plot top value and you will see sub expressions for box plot bottom, middle, and the upper and lower whiskers. The box top and bottom are required, but the others are optional.

Re: Box Plot- 2,3 datasets

avinashelite — Fri, 14 Oct 2016 05:43:51 GMT

Check this document

Creating a Candle light Chart or Box Plot Chart with custom Pop up of Plot values

Re: Box Plot- 2,3 datasets

Fri, 14 Oct 2016 06:52:27 GMT

Hej thanks, I can do that, but I have three different 'stations' which I want to compare and that is what I cannot find out.

So I want to have three box plots next to each other which shows my three datasets, so I can easyly compare their medians, shape etc.

THANKS!

time	SCA simpel	SCA målt	SCA detaljeret
01/01/2015 00:00	0.00	5930.00	0.00
01/01/2015 01:00	0.00	5874.00	0.00
01/01/2015 02:00	0.00	4855.00	0.00
01/01/2015 03:00	0.00	5698.00	0.00
01/01/2015 04:00	17.31	5595.00	0.00
01/01/2015 05:00	2534.66	6032.00	0.00
01/01/2015 06:00	4186.95	4612.00	607.44
01/01/2015 07:00	4285.92	4882.00	2135.49
01/01/2015 08:00	4730.40	5487.00	4233.53
01/01/2015 09:00	4730.40	4817.00	3650.71
01/01/2015 10:00	5212.88	4763.00	4204.24
01/01/2015 11:00	5451.25	4803.00	4730.40
01/01/2015 12:00	4730.40	5419.00	4730.40
01/01/2015 13:00	4730.40	6443.00	4730.40
01/01/2015 14:00	5829.52	5811.00	4954.26
01/01/2015 15:00	4730.40	6093.00	5818.17
01/01/2015 16:00	4730.40	6082.00	4765.38
01/01/2015 17:00	4730.40	6341.00	4730.40
01/01/2015 18:00	4730.40	6111.00	4730.40
01/01/2015 19:00	4730.40	5904.00	4730.40
01/01/2015 20:00	4045.48	5678.00	4730.40
01/01/2015 21:00	4349.34	6146.00	4730.40
01/01/2015 22:00	3259.43	6354.00	4730.40
01/01/2015 23:00	3850.04	5641.00	4730.40
02/01/2015 00:00	3856.91	6562.00	4730.40
02/01/2015 01:00	2644.72	5964.00	4730.40
02/01/2015 02:00	3869.34	6258.00	3260.12
02/01/2015 03:00	3132.99	5776.00	4234.88
02/01/2015 04:00	3029.58	5854.00	4628.64
02/01/2015 05:00	4196.34	6204.00	3041.26