Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tlambourne
Contributor II
Contributor II

Can I drop formatting of background when pivot table is expanded?

I have the a pivot table that has a formula which will determine what color the background should be based on the the results of the financial center. That works great. But when the pivot table is drilled down further the same formula wouldn't apply. Is it possible to only have the coloring applied when the Employee level is not expanded? (I have accomplished teh coloring by adding a formula to teh background of teh expression.)

Attached is pic of table

Formatting.PNG

1 Solution

Accepted Solutions
Gysbert_Wassenaar

That should be possible. You have an expression to calculate the background colors. Now you have to change that a bit so it takes into account the dimensionality level of the cell: If(Dimensionality()=1, ...color_expression... )


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

That should be possible. You have an expression to calculate the background colors. Now you have to change that a bit so it takes into account the dimensionality level of the cell: If(Dimensionality()=1, ...color_expression... )


talk is cheap, supply exceeds demand

View solution in original post

tlambourne
Contributor II
Contributor II
Author

Thanks that worked just as expected