Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi
Please find the attached app.
Have displayed Actual as bar and plan as line.
Regards
Harish