Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

arasantorule
Contributor III

Pivot table dimension's background color is not working as expected

Dear Friends,

We have an issue with Pivot table dimension's background color. It is a calculated dimension.

When there are null or zero on the cells for the row, the background color is not shown in the dimension.

I understand that, the above behavior is based on Qlikview Product Design.

Is there any workaround/fix to resolve this limitation?

Thanks a lot.

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Pivot table dimension's background color is not working as expected

Hi,

can you attach a sample app ? or some rows on an excel file with the expression used for the calculated dimension ?

qlik4asif
Contributor II

Re: Pivot table dimension's background color is not working as expected

Give a condition in Expression Backgroung colour as

If(Exp=Null() or Exp=0,RGB(give which color code you want)

Or

Right click on pivot table and Format cell option

arasantorule
Contributor III

Re: Pivot table dimension's background color is not working as expected

Hi,

The issue is the background color of the calculated dimension in the pivot table is working when corresponding rows have non null values for the aggregation expression.

Incase there are any null in the aggr result the background color is not working.

Thanks.

qlik4asif
Contributor II

Re: Pivot table dimension's background color is not working as expected

i also faced the same situation , i tried

Right click on pivot table and Format cell option   -   here you can give color

femkescholten
New Contributor II

Re: Pivot table dimension's background color is not working as expected

Did you ever find a solution? I'm running into the same issue 😞
Thanks