Pivot Table - Column condition based data display

[Azura777]

I have the following pivot table (created in QlikSense)

Two questions:

1. There are different dimensions (columns) which represents different fields, as can be seen in the print screen below. How can one go about to only display rows that contain values when any of the columns (arrow indicators on the print screen) have a value >0? Per dimension one can suppress values that are nul yet when one applies it to all the columns then nothing gets displayed. Only one one works perfect except that nothing else then displays. I could not find a way to correlate between the different columns/ dimensions/measures. Would be very helpful to get this working.

2. How does one change the dimension/ measure heading's background and font colour?

[brunobertels]

Hi 

in pivot table to show/hide column depending on values , use calculated dimension 

rather than put dimension REGION for exemple put 

aggr(if(MyMesure>0,REGION),REGION) 

Or use the panel option show/hide comlumn if : 

in pivot table you have an option to color Title , not available in straight table 

Hope it helps , Regards 

[Azura777]

Hi Bruno

The issue is that there is no correlation between dimensions (columns) to say (in laymen terms) that if Dimension A, B, C, D etc contains null or zeros to then hide those columns/ dimensions and associated rows.

The original print screen show the data as it is yet one would only like to see values (greyed are value segments) when the above criteria is met.

kind regards