topic Only Show the Total? in QlikView

Only Show the Total?

richnorris — Fri, 10 Sep 2010 10:39:20 GMT

Hi, is it possible to create a straight table, but then only show the totals? I thought about resizing it to only one row and disabling move / resize, but then you have a scrollbar that ruins it. Or maybe there's a better way to do what I'm doing? Essentially, I want to calculate the total volume by the top ten sites, and show just the total, not a breakdown, and then I want to show what percentage this is of the total volume?

Only Show the Total?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 10:52:35 GMT

Hello Rich,

I think using a text object properly formatted would help you do that. You can check the Gauge chart option as well.

Hope that helps

Only Show the Total?

jonathandienst — Fri, 10 Sep 2010 11:55:23 GMT

Depending on your expressions, it may be as simple as removing the dimensions from the table and disable totalling on the expressions. I often use this for summary information on a dashboard page, as an alternative to text boxes.

Another tip: turn on horizontal in the presentation tab.

Jonathan

Only Show the Total?

Mon, 07 May 2012 16:58:24 GMT

BUMP! I would like to be able to do this too. If you figured out how Rick, please let me know.

Only Show the Total?

Oleg_Troyansky — Mon, 07 May 2012 18:13:26 GMT

I believe the Straight Table with no dimensions shoujld do the trick of showing only totals.

Only Show the Total?

Mon, 07 May 2012 20:10:25 GMT

That is correct Oleg. My issue really was that I had to load the value I was summing for a subset of the total. But this is the answer to the question.