Advanced Variance in Chart

[aslam24196]

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.?

[techvarun]

sample data and expected output would help here

[aslam24196]

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):

[techvarun]

Please check the attached

[aslam24196]

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

[tresesco · Accepted solution]

Another UI solution could be like:

[techvarun]

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;

[aslam24196]

Thank You Tresesco.

This did it for me.

Wow Qlikview is more Dynamic than I thought.