topic Re: Custom totals in pivot table in QlikView

Custom totals in pivot table

Thu, 26 Mar 2015 11:03:16 GMT

I have a pivot table with a total column at the end.

What I ideally want is the following:

1) create my own custom total, summing up all the values of the week (at the moment the original expression is doing a count distinct)

2) move the total from the end of the table to the beginning

Is this possible? If yes, then how?

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 11:14:58 GMT

post the sample app

Re: Custom totals in pivot table

Thu, 26 Mar 2015 11:35:19 GMT

Hi,

Please see attached example file

As you can see in the example I am doing a distinct count on the customers and orders. But I want to total to appear as the first column and the total for Customer Count for example to appear as 9 and not 8

Thank you.

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 11:47:28 GMT

Hi have did a lil twist to solve your problem hope this solves your problem

find the qvw attached

count( DISTINCT Customers&[Financial Week])

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 11:48:09 GMT

Financial Week	W26 2015	W27 2015	W28 2015	Total
Customer Count	4	4	1	9
Order Count	3	4	3	10

Re: Custom totals in pivot table

Thu, 26 Mar 2015 11:59:28 GMT

Thanks for that.

So, there isn't a way of moving that total column from the end to the beginning is there?

As you can imagine, if you have multiple weeks, the total column will be pushed to the end, and you are constantly having to scroll across. So, ideally, can I achieve this:

Re: Custom totals in pivot table

Thu, 26 Mar 2015 11:59:48 GMT

Hi sabahsdada,

To move the total to the beginning of the table when pivoted horizontally:

Right click - properties - Presentation Tab click 'Subtotals on top'

Thanks

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 12:01:48 GMT

there is a way please find the attached qvw

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 12:02:49 GMT

PFA

Re: Custom totals in pivot table

Thu, 26 Mar 2015 12:03:01 GMT

Perfect thanks!! That worked

Re: Custom totals in pivot table

Thu, 26 Mar 2015 12:04:28 GMT

Example attached, hope this helps.

Re: Custom totals in pivot table

Thu, 26 Mar 2015 12:05:03 GMT

You beat me to it

Re: Custom totals in pivot table

Anonymous — Thu, 26 Mar 2015 12:06:35 GMT

he he philip , important is solving problem