topic Visualisation in Bar Chart in QlikView

Visualisation in Bar Chart

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one bar chart like below:

User wants to see the deviation b/w Actual and Planned.

Deviation: Actual * 100/Planned.

What would be the best way to show all three in single chart.

Please help.

Thanks,

Sarif

Re: Visualisation in Bar Chart

Anil_Babu_Samineni — Mon, 15 May 2017 10:21:56 GMT

You can do this?

Dev((Sum(Actual) * 100)/Sum(Planned),0)

Re: Visualisation in Bar Chart

mhmmd_srf — Mon, 15 May 2017 10:33:21 GMT

Need to create different Bar?

Re: Visualisation in Bar Chart

Kushal_Chawda — Mon, 15 May 2017 10:41:07 GMT

one option is "Straight table" in which you can show it all three in single chart.

If you want graphical representation, you can go with "Combo chart", in which you can show Actual & Plan as Bar and Deviation as line. You can go to chart properties->Axis tab-> change position of Actual & Plan as left and deviation as right.