Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Not applicable

Custom totals in pivot table

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?

12 Replies
Highlighted
Contributor III

Re: Custom totals in pivot table

post the sample app

Highlighted
Not applicable

Re: Custom totals in pivot table

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.

Highlighted
Contributor III

Re: Custom totals in pivot table

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

find the qvw attached

count( DISTINCT Customers&[Financial Week])

Highlighted
Contributor III

Re: Custom totals in pivot table

Financial Week W26 2015W27 2015W28 2015Total
Customer Count4419
Order Count34310
Highlighted
Not applicable

Re: Custom totals in pivot table

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:

Highlighted
Not applicable

Re: Custom totals in pivot table

Hi sabahsdada,


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

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

Thanks

Highlighted
Contributor III

Re: Custom totals in pivot table

there is a way please find the attached qvw

Highlighted
Contributor III

Re: Custom totals in pivot table

PFA

Highlighted
Not applicable

Re: Custom totals in pivot table

Perfect thanks!! That worked