topic Total line on a chart in QlikView

Total line on a chart

Tue, 09 Jun 2009 18:42:22 GMT

Hi,

I've realized a line chart with one dimension and one expression.
The chart rapresents the amount of sales of each branch...but I would like to show in the same chart a line that rapresents the total amount of sales of all branches.

It's possibile to realize ?
How can I do ?

Thanks a lot.

Total line on a chart

Tue, 09 Jun 2009 19:01:45 GMT

Hi,

check the attached image. Like wise you want to show a line (total sales of all branches) along with the sales of individual branches.

Let me know if my understanding is correct or wrong.

-Raghu

Total line on a chart

Tue, 09 Jun 2009 19:12:37 GMT

Exactly what I mean!

How can I realize this ?

Thanks a lot

Total line on a chart

Tue, 09 Jun 2009 19:50:31 GMT

go to "EXPRESSION" tab, select full accumulation at the bottom

then go to "PRESENTATION" tab Add an expression in the Reference lines like Sum(Salesamount).

try this and let me know

Thanks

Raghu.

Total line on a chart

Tue, 09 Jun 2009 20:02:53 GMT

I have found the "Full accumulation" but I can't understand where I have to add an expression in the Presentation tab.
In the Presentation tab I can only some properties of the chart like borders, colors, etc....

Maybe I haven't understood correctly.

I have even try to create another expression and set it as "Full accumulation" but the chart is unreadable.

Can you explain me again ?

Thanks a lot.

Total line on a chart

Tue, 09 Jun 2009 20:11:54 GMT

look at the attached image. If this will not works fine can you upload your document to me.

-Raghu

Total line on a chart

sathishkumar_go — Tue, 09 Jun 2009 20:49:02 GMT

Hi Syead,

Go for Presentation Tab --> Numbers on Data point

select Vertcal

thats it

Raghu I don't think so for reference lines is correct for this option

-Sathish

Total line on a chart

sathishkumar_go — Tue, 09 Jun 2009 20:56:29 GMT

oh sorry raghu

wrongly i send my previous post

Total line on a chart

Tue, 09 Jun 2009 21:45:45 GMT

It works...but I think the line isn' correct.

It is an horizontal and constant line on the top, like if it's a fixed value.
Instead, what I would like to see is a line near the lines detail so I can show how each branch follow or not the total line.

Can you understand me ?

Thanks

Total line on a chart

Wed, 10 Jun 2009 11:18:53 GMT

Hi,

Check the attached application.

- Sridhar

Total line on a chart

Wed, 10 Jun 2009 11:42:17 GMT

Hi Paul,

You can see , sales for Aus is high i.e. total Sales, so it must have contribute more for over all sales.

Have a look at this chart.

- Sridhar

Total line on a chart

Wed, 10 Jun 2009 16:05:53 GMT

"Hi,

Check the attached application.

- Sridhar"

Hi,

what you do is exactly what I mean but I have two problem now.
I use a drll-down dimension so I have to switch the "current dimension" to change the expressione "Sum (total<Country> Sales)".
If the drill-down is set to "City" for example I have to use this formula "Sum (total<City> Sales)".

How can I obtain this ?

Finally I have a problem with scale.
All data seem to be very very near each one because the "total one" have a large scale.
How can I let my chart more readable ?

Thanks a lot!
Bye.

Total line on a chart

Wed, 10 Jun 2009 16:34:27 GMT

Hi,

Check this attachment.

1 ) If this doesnt solve your purpose, then tell me your drill down groups and with regards to which dimension you would like to see the values for total sales.

2 ) With regards to your second query, try changing the axis for Total Sales as right in presentation tab.

- Sridhar

Total line on a chart

Wed, 10 Jun 2009 17:33:57 GMT

It works!

But I can I change the axis for Total Sales ?
Can you explain me with more details ?

Thanks a lot, really!

Bye

Total line on a chart

Wed, 10 Jun 2009 17:46:38 GMT

Ya Sayed, go to axes tab and choose the expression from expression axes for which you want to change the axes i.e. here Total Sales. and below the sales frame you can fine the position frame from that choose the axes i.e if your default axes as left, then choose it as right.

Check the attached doc for more info.

Cheers

- Sridhar