Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display expression at a certain level only

Hi

I have a pivot chart which looks like this:

1.jpg

How can I display the expression, only at the Total Level? and looks like this:

2.jpg

This is because SaleReps is a numeric column coming from a less granular table

thanks in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Modify the expression:
if(dimensionality()<=1, sum(SaleReps))

Regards,
Michael

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Modify the expression:
if(dimensionality()<=1, sum(SaleReps))

Regards,
Michael