total line in line chart with dimensions

[#1]

Hi Community,

I have a line chart with the following dimensions:

Date

Category (3 types)

And the expression:

Count(uid)

I want to display this chart as it is but with an additional line for (Total Sales). I have tried adding another expression but then the breakdown by category doesn't work anymore.

Any help would be greatly appreciated!

Thanks

Gareth

[Miguel_Angel_Baeyens]

Hello Gareth,

If you mean a grand total line (and only that) you can add Partial Sums in the Presentation tab of the chart properties, using this conditional to show the count, but a grand total of sum, as the expression

If(dimensionality() = 0, Sum(Sales), Count(uid))

Is that what you are looking for?

[#3]

Thanks for your response!

I can't seem to get that to work and looking at my example I'm not sure I was quite correct in my description.

I have a chart with individual lines for a count (uid) across categories. I want an additional line that is a count of total (i.e. the total count = sum of the count of all categories).

Thanks

Gareth

[Miguel_Angel_Baeyens]

Hello Gareth,

That's what I understood, but I may give the wrong answer. If the chart is a straight table, go the "Expressions" tab in the chart properties, and set "Total Mode" to "Sum of Rows".

Is this what you are looking for?

[stevelord]

Hi, I was trying to get a total line for all companies in a line chart that would stay put after I selected individual companies on my list box and found this solution.

First, unselect everything so the total shows up on the line chart.

Then, right-click on the line on the line chart and select 'Set Reference' to make it a reference line.

Finally, go back to your list boxes and select whatever you want.  The totals line you set as a reference stays there and lines related to your specific selections appear below it.  I have 2 expressions and the reference line appeared for both.  (There is no show totals in the presentation tab for line charts, though it seems like a simple enough capability for someone to add.)

This reference line will stick if you set this up as a dashboard for someone, but end users are not able to toggle the reference line as I understand.  (You can right-click and select Clear Reference to remove it in the qvw file object yourself though.)  At the least, they could add Total to that reference lines list on the one tab with the AVG and polynomial and linear etcetera...

[#6]

I think here is your answer..

http://community.qlik.com/message/224029#224029