Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Is there anyway I can replicate this chart in QlikView?

I am struggling to create this chart in Qlik. I can create the bars by expressions like Forecast C = Forecast C- Forecast B- Forecast A. but how can I show the Actual values?

6 Replies
Champion III

Can you share your sample file with some data to look into?

Anonymous
Not applicable
Author

Actually, I need to create a graph like this so I don't have any qvw file but I can share the script for the bars.

City, ForecastA, ForecastB, ForecastC, Measurement

Detroit, 6, 14, 25, Forecast

];

City, ActualA, ActualB, ActualC, Measurement

Detroit, 4, 12, 15, Actual

];

Forecast bar is what I want to do and Actual bar shows what I can accomplish.

Champion III

Try this?

City:

City, ForecastA, ForecastB, ForecastC, Measurement

Detroit, 6, 14, 25, Forecast

];

Concatenate

City, ActualA, ActualB, ActualC, Measurement

Detroit, 4, 12, 15, Actual

];

Dim: like below image

For measurement dimension uncheck Show Legend.

= Sum(ActualA)

= Sum(ActualB)-Sum(ActualA)

=Sum(ActualC) -Sum(ActualB)

= Sum(ForecastA)

=Sum(ForecastB)

=Sum(ForecastC)

Below is what you get

Anonymous
Not applicable
Author

Yes. I can replicate that but what I want is to 25 bar as 25-14-6 = 5 height, 14 bar as 8 respectively. but the number inside the bar should show 25,14,6. Let me know if you do not understand my question. Thank you.

Champion III

try below for Forecast expressions:

= Sum(ForecastA)

= Dual(Sum(ForecastB), Sum(ForecastB) - Sum(ForecastA))

=Dual(Sum(ForecastC), Sum(ForecastC) - Sum(ForecastB) - Sum(ForecastA))

MVP

Hi,

maybe one solution could be:

Dual(Sum(Value),RangeSum(Sum(Value),-Above(Sum(Value))))

Color(RowNo()) bitand ARGB(Pick(Match(Measurement,'Actual','Forecast'),120,255),255,255,255)

```tabValues:
CrossTable (Type, Value, 2)
City, Measurement, A, B, C
Detroit, Forecast, 6, 14, 25
Lund, Forecast, 10, 16, 20
];

CrossTable (Type, Value, 2)
City, Measurement, A, B, C
Detroit, Actual, 4, 12, 15
Lund, Actual, 11, 18, 22