QlikView App Dev

[Anonymous]

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?

[vishsaggi]

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

[Anonymous]

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.

[vishsaggi]

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

[Anonymous]

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.

[vishsaggi]

try below for Forecast expressions:

= Sum(ForecastA)

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

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

[MarcoWedel]

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