topic Re: Variance in chart in QlikView

Variance in chart

aslam24196 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have a table with 3 attributes,

Year, Country and Sales.

What I want to achieve is to create a Chart which shows the total sales By Each Year.

This can be achieved by Using Year as Dimension and sum(Sales) as Expression.

But my requirement is like this.

The Chart needs the following in the Dimention

Year as Bars

and Current Year vs Previous Year Variance as Line Graph

The Calculation is for example (Sales(2011) - Sales(2010))/sales (2010)

Is this Feasible in Qlikview 12. If So? How?

zhadrakas — Mon, 22 Jan 2018 11:59:04 GMT

check the qvw. This should help you.

you Need to Change the variance Expression. Its just to Show you how to get there.

regards

tim

aslam24196 — Mon, 22 Jan 2018 12:22:52 GMT

Sorry Tim, I am out of the External QVW limit.

Can you post screenshots if possible

Thank You

zhadrakas — Mon, 22 Jan 2018 12:31:03 GMT

sure

1) create Combo chart

2) Dimension = year

3) Expressions

3.1) sum(Sales) as Bar

3.2) sum(Sales) / above(sum(Sales)) as Line

at this point you have something like this

if you want to split the axes, goto axes tab

then i looks like:

aslam24196 — Wed, 24 Jan 2018 09:38:43 GMT

Thanks Tim,

This Worked Perfectly.

Though my Requirement is bit Complicated. Just See if this is possible.

I have data in the Order

Q4 Budget Q1 Q2 Q3

Now I want the chart to display :

Budget/Q4 Q1/Budget Q2/Budget Q3/Budget.

It is even okay if these are a part of separate chart.