Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Visualisation in Bar Chart

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

3 Replies
Anil_Babu_Samineni

You can do this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mhmmd_srf
Creator II
Creator II

Need to create different Bar?

Kush
MVP
MVP

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.