Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
pranaview
Contributor II

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

1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

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

Hi,

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

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

2 Replies
sergio0592
Valued Contributor II

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

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
Contributor II

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

Hi Sergio,

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

Cheers,

Pranav