Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
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
Highlighted
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 ?

Highlighted
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

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.

Highlighted
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

Highlighted
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