Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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?

Qlik.PNG

6 Replies
Highlighted
Champion III
Champion III

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

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

Highlighted
Contributor
Contributor

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

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.

Highlighted
Champion III
Champion III

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

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.

Capture.PNG

Then your expr:

= Sum(ActualA)

= Sum(ActualB)-Sum(ActualA)

=Sum(ActualC) -Sum(ActualB)

= Sum(ForecastA)

=Sum(ForecastB)

=Sum(ForecastC)

Below is what you get

Capture.PNG

Highlighted
Contributor
Contributor

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

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.

Highlighted
Champion III
Champion III

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

try below for Forecast expressions:

= Sum(ForecastA)

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

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

Capture.PNG

Highlighted

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

Hi,

maybe one solution could be:

QlikCommunity_Thread_312623_Pic1.JPG

QlikCommunity_Thread_312623_Pic2.JPG

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

QlikCommunity_Thread_312623_Pic3.JPG

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