topic Total in Line Chart in QlikView

Total in Line Chart

gajapathy74 — Tue, 09 Mar 2010 13:38:22 GMT

Hi,

Is there a way, we could draw total line in the line chart.

Assuming I have a LINE chart which should have line per branch with the following.

X-Axis -- Month

Y-Axis -- Sales

In this chart I wanted to display a Total LINE in addition to the existing lines.

I have attached sample QVW file for ready reference.

Thanks in advance.

Total in Line Chart

Tue, 09 Mar 2010 13:53:13 GMT

One way is to build a Branch called 'Total' in the script.

Temp:

LOAD * INLINE [

Month, Branch, Sales

Jan, A, 500

Jan, B, 450

Jan, C, 475

Feb, A, 480

Feb, B, 465

Feb, C, 480

Mar, A, 490

Mar, B, 470

Mar, C, 480

];

Concatenate (Temp)

Load Month,

'Total' as Branch,

sum(Sales) as Sales

Resident Temp

Group by Month;

Total in Line Chart

gajapathy74 — Tue, 09 Mar 2010 14:19:07 GMT

Hi Ben,

Thank you for your quick reply. We can't use concatenate load to get branch total, because we have other filters like country, sales rep, etc, which will determine the data that needs to be plotted branch wise.

I have checked few post in the forums and most of the response I seen there is to go with mix of bar chart and line chart, which I don't want to.

Please let me know if you have any other alternate.

Regards,

Total in Line Chart

Tue, 09 Mar 2010 14:21:31 GMT

Hi,

see the example for more details.

Good luck!

Rainer

Total in Line Chart

gajapathy74 — Tue, 09 Mar 2010 16:02:19 GMT

Hi Rainer Filoda,

Thank you for your effort. I have checked the file uploaded by you and found that it is displaying the total across month, branch. Is there a way I can draw a line which shows the total line on a monthly basis.

Please find attached the image for your reference.

Regards,

Total in Line Chart

Tue, 09 Mar 2010 17:26:28 GMT

Here's one way.

Tom

Total in Line Chart

gajapathy74 — Tue, 09 Mar 2010 18:03:08 GMT

Hi Tom,

Thank you for your post. This would be OK if I have only branch filter. But as I mentioned earlier post, I have other filters like Country, Sales Rep., Year, Month, etc. This sample file uploaded here is to give some idea, but originally I am loading the data from a database. All the filters are driven by a user choice and based on the selection I need to show the detail at run time.

Please let me know if you need further information.

Regards,

Total in Line Chart

Fri, 29 Oct 2010 11:36:32 GMT

Hi all

I m also having the same problem for the last two months....

Could anyone help me...

we r not having only company,we also have subsector,sector....

thanks and regards

Gopinathan

Total in Line Chart

Thu, 10 Mar 2011 05:58:17 GMT

Hi All,

I'm also looking for the same. but still no solution yet.

The alternative:

i'm using is SET. Have a look at the attached. You will need to remove branch from dimension.

Then, in the expression, you do SET to detect each branch. the IF statement in front, is for cosmetic, so when user select one branch, it will show the total with the branch only. instead of showing all, to reduce the data on the screen.

This is not a good solution when you have a thousand branches.... You get the idea....

until then, i'm still looking if there's any ways to put branch in dimension, and without changing the data, we have the total lines.