Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
MVP
MVP

Re: Evaluate for Total Row in Pivot Table

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
Highlighted
MVP
MVP

Re: Evaluate for Total Row in Pivot Table

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

Highlighted
Contributor
Contributor

Re: Evaluate for Total Row in Pivot Table

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