topic Re: Plan vs Actual in QlikView

Plan vs Actual

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

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

Re: Plan vs Actual

vikasmahajan — Mon, 03 Oct 2016 07:41:13 GMT

Hi ,

Refter this

Actual-V-Budget

Vikas

Re: Plan vs Actual

vikasmahajan — Mon, 03 Oct 2016 07:43:29 GMT

Refer this too

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

Vikas

Re: Plan vs Actual

Anonymous — Mon, 03 Oct 2016 07:46:23 GMT

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

Re: Plan vs Actual

Anil_Babu_Samineni — Mon, 03 Oct 2016 07:53:37 GMT

You can create Combo chart

Plan is line Chart and Actual is Bar Chart

For Ref, PFA

Re: Plan vs Actual

Anonymous — Mon, 03 Oct 2016 08:08:00 GMT

Combo chart

Re: Plan vs Actual

nagarjuna_kotha — Mon, 03 Oct 2016 08:55:21 GMT

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

Re: Plan vs Actual

akpofureenughwu — Mon, 03 Oct 2016 09:04:55 GMT

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?

Re: Plan vs Actual

akpofureenughwu — Mon, 03 Oct 2016 09:05:32 GMT

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?

Re: Plan vs Actual

nagarjuna_kotha — Mon, 03 Oct 2016 09:11:30 GMT

Can share what is your expected output?

That would be helpful

-Nagarjun

Re: Plan vs Actual

antoniotiman — Mon, 03 Oct 2016 09:24:31 GMT

Hi,

may be

Temp:
LOAD SubField(field,'(',1) as field,
If(SubField(field,'(',-1) = 'actual)','A' ,'P') as [A/P],
January,
February
FROM
"https://community.qlik.com/servlet/JiveServlet/download/1135127-248023/test.xlsx"
(ooxml, embedded labels, table is Sheet1);

CrossTable(Month,Value,2)
LOAD field,
[A/P],
January,
February
Resident Temp;

Drop Table Temp;

Regards,

Antonio

Re: Plan vs Actual

akpofureenughwu — Mon, 03 Oct 2016 09:28:41 GMT

In the attached file, you will see the various location are stack, (their actual are expressed using a bar chart) and their plan as a line chart...

against month of the year.

This is my desired output.

Regards

Re: Plan vs Actual

harishkumarg — Mon, 03 Oct 2016 09:52:49 GMT

Please find the attached app.

Have displayed Actual as bar and plan as line.

Regards

Harish