Plan vs Actual

[akpofureenughwu]

Good day all,

I need help,

I have a table with plan and actual...

I need to build a chart with the plan represented in a linechart while the actual in a bar chart (in the same plot)

Please find attached file for clarity. Thanks in advance

Regards

[vikasmahajan]

Hi ,

Refter this

Actual-V-Budget

Vikas

[vikasmahajan]

Refer this too

https://community.qlik.com/thread/185897

Vikas

[Anonymous]

Hello Akpofure

You can use a combo chart . However your plan and actual are available as values of field.

KIndly find attached application if it resembles something u need??

!

Thanks & Regards

Chintan

[Anil_Babu_Samineni]

You can create Combo chart

Plan is line Chart and Actual is Bar Chart

For Ref, PFA

[Anonymous]

Combo chart

[nagarjuna_kotha]

If you do not have flag to filter Atual and plan in ur data create calucualted dim like i did chart and take combo chart and one exp for Bar and another one for Line.

I hope this may helps you.

-Nagarjun

[akpofureenughwu]

Thanks for your response, the above design... Won't be great since I want the dimension to be Benin, Jos and not actual and plan...

Thanks..

Can that be achieved?

[akpofureenughwu]

Thanks for your response, . Won't be great since I want the dimension to be Benin, Jos and not actual and plan...

Thanks..

Can that be achieved?

[nagarjuna_kotha]

Can share what is your expected output?

That would be helpful

-Nagarjun