topic Re: Pivot table background color in cells with no data in QlikView

Pivot table background color in cells with no data

Wed, 08 May 2013 06:33:55 GMT

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.

Re: Pivot table background color in cells with no data

kumarnatarajan — Wed, 08 May 2013 07:02:02 GMT

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.

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:04:24 GMT

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

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:12:05 GMT

Use If(IsNull(Filedname))

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:16:19 GMT

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?

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:18:24 GMT

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)))

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:22:26 GMT

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

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:31:20 GMT

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.

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 07:39:40 GMT

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

Re: Pivot table background color in cells with no data

Wed, 08 May 2013 10:46:51 GMT

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

Thanks a lot 🙂

Jesper