topic Re: Variance in a Chart - Excel example included in QlikView

Variance in a Chart - Excel example included

Mon, 04 Jul 2011 09:57:03 GMT

I want to create a chart with one dimension (material) and 4 formulas. I have difficulties with the variance.

There is a "quota", "cost of sales" and "avg price" which are no trouble, but there is a range (min price, max price) and I want to display this range within the chart.

Enclosed is a exapmle from Excel.

Is it possible to create a chart like the excel chart within QlikView?

Thanks a lot in advanced.

Variance in a Chart - Excel example included

Mon, 04 Jul 2011 10:06:31 GMT

Thats the chart I want to see in QV, the problem ist the yellow chart (max -min price)

Variance in a Chart - Excel example included

christian77 — Mon, 04 Jul 2011 10:20:25 GMT

Hi:

It is going to be difficult. Those yellow boxes look to me as Box & Mustache boxes. The yellow box tells you the area that includes 95 % of the population. Red and Blue beams are specific values in the sample.

You may want to use grouped bars in your graphic to simulate that effect.

Re: Variance in a Chart - Excel example included

kaushiknsolanki — Mon, 04 Jul 2011 10:27:24 GMT

Hi,

Have a look at this example.

Regards,

Kaushik Solanki

Variance in a Chart - Excel example included

Mon, 04 Jul 2011 11:26:16 GMT

Thanks a lot to both. Kaushik.solanki, this example is perfekt.