topic Re: Add a sum bottom line to a pivot table chart in QlikView

Add a sum bottom line to a pivot table chart

Mon, 01 Aug 2011 08:34:16 GMT

Hi,

I created a simple webanalytics pivot table chart whose structure is :

Dimension :

Metrics :

As a result when i select year 2006 for example (yeah thos are totally fake data) :

I'd like to add a bottom line wich sum metrics wich remain visibles for dates selected, just like the yellow line added on my screenshot (dates are selected from a calendar.)

Could you help me ?

Thank you so much

Add a sum bottom line to a pivot table chart

SunilChauhan — Mon, 01 Aug 2011 08:37:46 GMT

go t presentation and check on partial sum

and seleect there sub total on bottom

it may give u desired result.

Thanks

sunil Chauhan

Add a sum bottom line to a pivot table chart

Mon, 01 Aug 2011 08:47:23 GMT

actually it works but only when some line is selected into the table.

i'd like to display total even when users didn't selected anything, is it possible ?

Add a sum bottom line to a pivot table chart

SunilChauhan — Mon, 01 Aug 2011 08:49:24 GMT

can u share some sample

Add a sum bottom line to a pivot table chart

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 08:52:23 GMT

Hello,

If you set the subtotal on top it behaves the same showing only when you click? Have you set any conditional in the totals? Are you using a pivot or a straight (obvious perhaps, but they may work different)?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Add a sum bottom line to a pivot table chart

Mon, 01 Aug 2011 09:02:26 GMT

Hello,

I'm using a pivot table.

When i switch from "Subtotals at bottom" to "Subtotals on top", there is no differences.

What i'd like is a permanent totals line at the bottom of my table.

Do you think i shoud try with a straight table ?

Add a sum bottom line to a pivot table chart

Mon, 01 Aug 2011 09:19:10 GMT

thank you, i found a way (addind another table.)

Re: Add a sum bottom line to a pivot table chart

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 10:03:44 GMT

Hi,

Nope, that should work regardless the type of chart. A straight table makes more sense when the chart will display all information for every possible value in dimension, as opposed to the pivot, that you can expand and collapse (say year, month, date) and pivot dimensions and expressions horizontal to vertical and viceversa.

But it sounds very strange that the partial sums line only shows up when some selections are done... Does that happen when they view the chart in the Desktop application, AJAX, plugin? What if the chart shows a small number of rows? Does the total row shows up? Or is that they have to scroll down and for some reason the scroll bar is not visible?

Check the attached application. I've set the partial sums row at top, but you don't need to select any value to get the totals.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Add a sum bottom line to a pivot table chart

llauses243 — Mon, 01 Aug 2011 23:59:32 GMT

Hi Sabrina ,

This is my offer, pls to see image adjust

Good luck, Luis.