Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Variance in a Chart - Excel example included

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Variance in a Chart - Excel example included

Hi,

    Have a look at this example.

Regards,

Kaushik Solanki

4 Replies
Not applicable

Variance in a Chart - Excel example included

barchart.jpg

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

christian77
Valued Contributor

Variance in a Chart - Excel example included

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

Hi,

    Have a look at this example.

Regards,

Kaushik Solanki

Not applicable

Variance in a Chart - Excel example included

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

Community Browser