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

[pranaview]

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

[sergio0592 · Accepted solution]

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]

Hi Sergio,

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

Cheers,

Pranav