topic Re: Sub Totals in QlikView

Sub Totals

Anonymous — Mon, 12 Jan 2015 22:03:45 GMT

Hi guys,

Is there possible to show sub total for whole set?

For example:

Store Country Zone District Count

1 Canada 2 25 5

2 Canada 2 25 3

3 Canada 2 25 1

4 Canada 2 25 10

TOTAL 19

8 Canada 2 26 15

10 Canada 2 26 13

13 Canada 2 26 11

14 Canada 2 26 20

TOTAL 59

???

I used show partial sums, it works only when I select my District

Re: Sub Totals

Mon, 12 Jan 2015 23:05:58 GMT

Attached. You have to use 'Show partial sums' for Store and have Store as the last Dimension. The hierarchy should be intact. Highest level dimension first then the next and so on.

Thanks

Re: Sub Totals

Anonymous — Tue, 13 Jan 2015 14:33:40 GMT

Yes, it works, but in my case store is on first place.

Re: Sub Totals

reshmakala — Tue, 13 Jan 2015 19:52:00 GMT

Why dont you demote the position of the dimension?

Re: Sub Totals

Anonymous — Tue, 13 Jan 2015 23:03:03 GMT

The client sent an example with store level in begging.

Re: Sub Totals

stevedark — Tue, 13 Jan 2015 23:35:34 GMT

Your best bet is to explain to them how Pivot tables function in QlikView, and why the group you are totalling must be to the left hand side.

However. If that is not going to work you may be able to do something by putting in a dummy dimension. If you create a calculated dimension to go first, with a value of:

=Dual('', District)

And a label of:

=' '

Can you then total on that dimension?

The dual function will maintain the numeric value of the district, but will display the empty string as the text, so you will get a blank column on which you can do the total. You will probably want to set the Total label to =' ' as well, so you can make the dummy column as small as possible.

Just a thought.

Steve