topic Re: How to highlight NULL-valued cells in dimension in QlikView

How to highlight NULL-valued cells in dimension

Thu, 01 Oct 2015 13:34:27 GMT

Hello

How can I highlight NULL-valued cells in dimension of Straight table?

For example how can I process dimension cell value in background color expression?

Thank you!

Re: How to highlight NULL-valued cells in dimension

Anonymous — Thu, 01 Oct 2015 13:38:34 GMT

Maybe something like :

if ( not len( [YourField] > 0 , red())

Re: How to highlight NULL-valued cells in dimension

rubenmarin — Thu, 01 Oct 2015 13:43:02 GMT

Or: If(IsNull(Field_Name), ColorFunction())

Re: How to highlight NULL-valued cells in dimension

Thu, 01 Oct 2015 14:44:33 GMT

I have used IsNull(Field_Name)

It works only if no filters applied.

=if(isnull([Клиент CRM]), rgb(225, 45, 45))

Re: How to highlight NULL-valued cells in dimension

rubenmarin — Thu, 01 Oct 2015 14:55:46 GMT

I have something similar in one app and is working, maybe in some conditions it stops working, mine was a simple straight table.

Can you upload a sample? I'm curious to know when it stops working.

Anyway you can try the solution proposed by Bill, just close the Len():

if ( not len( [YourField]) > 0 , red())

Re: How to highlight NULL-valued cells in dimension

Anonymous — Thu, 01 Oct 2015 15:05:36 GMT

Ooops!! Thanks RubenMarin for mending my typo, them brackets can be slippery blighters.

Re: How to highlight NULL-valued cells in dimension

Thu, 01 Oct 2015 15:46:21 GMT

See project attached.

You can select someting in field Curr.

Re: How to highlight NULL-valued cells in dimension

Anonymous — Thu, 01 Oct 2015 17:09:32 GMT

You have got Set Analysis in your 2 expressions to force them to override the manual selections for Curr to select r & u respectively. So your manual selections will never work properly and things will generally be messed up

Try using a Pivot Table adding Curr as a dimension and with just one expression to sum Val, Always Fully Expanded with the Curr Dimension dragged from the left to the top.

Hard to explain in writing.............. see attached.

Re: How to highlight NULL-valued cells in dimension

Mon, 05 Oct 2015 07:55:55 GMT

Thank you for your work!

It was helpful.

But the question "how can I process dimension cell value in background color expression?" still not answered.