Pivot table background color in cells with no data

[#1]

Dear Sirs,

I have a PL statement in a pivot table, and on one of my expressions i need a fixed background color.

However, the background color formula does not apply if the cells has no data (marked with yellow in screen shot)

How to fix?

My data is both ODBC, excel and script-internal calculations.

[kumarnatarajan]

Hi,

Go to expression Tab then click your expressions plus button then you can able to add the conndition for Backround color. See the below screen Short.

[#3]

Thanks, i tried just that. And it works fine if the cells contain data/values.

But the color-expression does not apply to cells with no data. The formula i typed is rather simple RGB(240,240,240)

Jesper

[#4]

Use If(IsNull(Filedname))

[#5]

Thanks. Tried this: (the expression formula is sum(BudgetAmount3)

if(isnull(BudgetAmount3) , rgb(240,240,240) , rgb(240,240,240))

but still doesnt work.

Other suggestions?

[#6]

Use this,

this will solve ur prblm

=If(Manpower=5,RGB(0,0,128),

               If(IsNull(Manpower),RGB(0,128,0),RGB(128,0,0)))

[#7]

Thanks. Cant get it to work though. Problem is that data is missing and QV dont have data to put into the color calculation.

Accordign to this thread its impossible to fix

http://community.qlik.com/message/187996#187996

Might try to load some dummy-records and zero-values to fill in to the missing spaces.

Thanks for the replies.

Jesper

[#8]

Boss try this,

If(IsNull(FieldName),RGB(0,128,0),RGB(128,0,0)))

the statement itself says if the field is null then show the respective color....

rest is on ur wish.

[#9 · Accepted solution]

Loading Dummy Records is nt good practice... refer the attached application

[#10]

It works, i only needed to uncheck 'supress zero values'

Thanks a lot 🙂

Jesper