topic Re: Advanced Variance in Chart in QlikView

Advanced Variance in Chart

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

Hi Guys,

My Requirement seems a bit Complicated. Just See if this is possible.

I have data for sales in the Order

Q4 Budget Q1 Q2 Q3

Now I want the chart to display :

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

for Sum(Sales)

Is this possible.?

Re: Advanced Variance in Chart

techvarun — Mon, 29 Jan 2018 05:51:31 GMT

sample data and expected output would help here

Re: Advanced Variance in Chart

aslam24196 — Mon, 29 Jan 2018 06:12:21 GMT

Okay Consider This:

Time Period Sales

---------------- --------

Q4 20

Budget 25

Q1 30

Q2 35

Q3 30

Now I Need a line chart which displays the following four Values (Variance):

Re: Advanced Variance in Chart

techvarun — Mon, 29 Jan 2018 06:41:36 GMT

Please check the attached

Re: Advanced Variance in Chart

aslam24196 — Mon, 29 Jan 2018 06:48:04 GMT

Hey Varun,

I use a free desktop version of qlikview and i am out of my external qvw limits.

If possible can you share screenshots.

Thank You

Re: Advanced Variance in Chart

tresB — Mon, 29 Jan 2018 06:58:18 GMT

Another UI solution could be like:

Re: Advanced Variance in Chart

techvarun — Mon, 29 Jan 2018 07:23:47 GMT

Set vBudget= 25;


Test:
LOAD * INLINE [
    Time, Sales
    Q4, 20
    Q1, 30
    Q2, 35
    Q3, 30
];




Load Time, If(Time = 'Q4', Sales - $(vBudget),$(vBudget)-Sales) as Variance,
If(Time = 'Q4', (Sales - $(vBudget))/$(vBudget),($(vBudget)-Sales)/Sales) as Pecentage,
If(Time = 'Q4','Budget vs'&Time, Time &'vs Budget') as Lable Resident Test;


Drop table Test;

Re: Advanced Variance in Chart

aslam24196 — Mon, 29 Jan 2018 09:29:53 GMT

Thank You Tresesco.

This did it for me.

Wow Qlikview is more Dynamic than I thought.