Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is Total mode for expressions possible in Pivot tables?

From time to time I use AVG of rows in total mode for straight table, but that option isn't available in Pivot table.. Can it somehow become possible?

1 Solution

Accepted Solutions
mov
Employee
Employee

I asume yopu mean that the total expression should be different than the "line" expression. If this is correct, make your expression conditional, using, for example, dimensionality(). It may look like this:
if(dimensionality()=0, avg(...), sum(...))
(If I remember correctly, dimensionality()=0 for the tola row. Can't test now.)

View solution in original post

2 Replies
mov
Employee
Employee

I asume yopu mean that the total expression should be different than the "line" expression. If this is correct, make your expression conditional, using, for example, dimensionality(). It may look like this:
if(dimensionality()=0, avg(...), sum(...))
(If I remember correctly, dimensionality()=0 for the tola row. Can't test now.)

Not applicable
Author

I had this same problem, dimensionality() works perfect, BUT:

- How about the total line label?? it's now 'total' but i like to have 'Average'

- Is it also possible to have 2 total lines? (one with the avg() and one with the count()??)