Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
aslam24196
Contributor III
Contributor III

Advanced Variance in Chart

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Another UI solution could be like:

Capture.JPG

View solution in original post

7 Replies
techvarun
Specialist II
Specialist II

sample data and expected output would help here

aslam24196
Contributor III
Contributor III
Author

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

New Bitmap Image.jpg

techvarun
Specialist II
Specialist II

Please check the attached comm.PNG

aslam24196
Contributor III
Contributor III
Author

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
MVP
MVP

Another UI solution could be like:

Capture.JPG

techvarun
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

Thank You Tresesco.

This did it for me.

Wow Qlikview is more Dynamic than I thought.