Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jackm75
Creator
Creator

Evaluate for Total Row in Pivot Table

I'm looking to be able to identify the Total Row (Show Partial Sums) with an IF statement.  How can I do that?

Example:  IF(<Total Row>=True, Do This, Do That)

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have a look at Dimensionality() resp. Secondarydimensionality() functions in the Help file. Also search for 'examples of chart inter record functions' for a some samples.

View solution in original post

2 Replies
swuehl
MVP
MVP

Have a look at Dimensionality() resp. Secondarydimensionality() functions in the Help file. Also search for 'examples of chart inter record functions' for a some samples.

jackm75
Creator
Creator
Author

Thanks for pointing me in the right direction, swuehl.  With Dimensionality, I was able to achieve what I was after!