topic Re: Is there anyway I can replicate this chart in QlikView? in QlikView

Is there anyway I can replicate this chart in QlikView?

Anonymous — Thu, 30 Aug 2018 19:58:16 GMT

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?

Re: Is there anyway I can replicate this chart in QlikView?

vishsaggi — Thu, 30 Aug 2018 20:47:44 GMT

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

Re: Is there anyway I can replicate this chart in QlikView?

Anonymous — Thu, 30 Aug 2018 20:58:07 GMT

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.

LOAD * INLINE [

City, ForecastA, ForecastB, ForecastC, Measurement

Detroit, 6, 14, 25, Forecast

];

LOAD * INLINE [

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.

Re: Is there anyway I can replicate this chart in QlikView?

vishsaggi — Thu, 30 Aug 2018 21:25:31 GMT

Try this?

City:

LOAD * INLINE [

City, ForecastA, ForecastB, ForecastC, Measurement

Detroit, 6, 14, 25, Forecast

];

Concatenate

LOAD * INLINE [

City, ActualA, ActualB, ActualC, Measurement

Detroit, 4, 12, 15, Actual

];

Then using bar chart add

Dim: like below image

For measurement dimension uncheck Show Legend.

Then your expr:

= Sum(ActualA)

= Sum(ActualB)-Sum(ActualA)

=Sum(ActualC) -Sum(ActualB)

= Sum(ForecastA)

=Sum(ForecastB)

=Sum(ForecastC)

Below is what you get

Re: Is there anyway I can replicate this chart in QlikView?

Anonymous — Tue, 04 Sep 2018 16:32:33 GMT

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.

Re: Is there anyway I can replicate this chart in QlikView?

vishsaggi — Tue, 04 Sep 2018 17:51:19 GMT

try below for Forecast expressions:

= Sum(ForecastA)

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

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

Re: Is there anyway I can replicate this chart in QlikView?

MarcoWedel — Wed, 05 Sep 2018 22:38:46 GMT

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)
LOAD * INLINE [
    City, Measurement, A, B, C
    Detroit, Forecast, 6, 14, 25
    Lund, Forecast, 10, 16, 20
    Radnor, Forecast, 13, 17, 23
];

CrossTable (Type, Value, 2)
LOAD * INLINE [
    City, Measurement, A, B, C
    Detroit, Actual, 4, 12, 15
    Lund, Actual, 11, 18, 22
    Radnor, Actual, 14, 19, 26
];

hope this helps

regards

Marco