Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Help with Pivot table

In Pivot table if we have selected to show the partial sum then it automatically sum ups the group values, is there any way to skip this. I want to show the total but not the summation of group values, some other mathematical calculation result; is it possible.

3 Replies
thomas_skariah
Contributor III

Re: Help with Pivot table

Hi Ram,

Can you forward a sample application.

Regards,

Tom

MVP
MVP

Re: Help with Pivot table

Hi

You can use Dimensionality() to identify the total rows and create an expression that use Dimensionality like this:

If(Dimensionality() = 0, <total row expression here>, <detail row expression here>)

If you have more than one dimension, then the value of Dimensionality will equal the number of dimensions for the detail rows. The partial sums will have Dimensionality values between one less than the number of dimensions to 0, according to the partial sum level. The total row, or partial total row expression will often be a Sum(Aggr()) type of expression.

If you provide more information on your requirements, then we can help you with the expression.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Help with Pivot table

Hi Ram,

Please find the attached table and let me know if you require the result as follows.

AfghanistanOlivier Simenon20072150 
AlbaniaJohn Lemon20066000 
20082590 
ArmeniaMario Kaddafi20071850 
AustraliaRolf Wesenlund20051030 
20061210 
Total 14830

Regards

Mayank

Community Browser