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: 
pranaview
Creator III
Creator III

How to assign background/text color to Total column in the Pivot table only after the expansion

Hi All,

Problem: I have a pivot table which has multiple columns. I want to assign background/text color to the Total value but only when the all the columns are expanded based on a condition, for ex : If(Count(Distinct(Field)) > 50,Red()) or something like this. But I don't want the condition to work on the default view. It should only be applicable when for a row all the columns are expanded.

Please let me know if there's any way i can implement this.

Thanks,

Pranav

Labels (4)
1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

Try to use dimensionality() function, it should help you.

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dimensionality/ta-p/1485559

pranaview
Creator III
Creator III
Author

Hi Sergio,

Thanks a lot. That's exactly something I was looking for.

Cheers,

Pranav