Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to highlight NULL-valued cells in dimension

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!

8 Replies

Re: How to highlight NULL-valued cells in dimension

Maybe something like :

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

Re: How to highlight NULL-valued cells in dimension

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

Not applicable

Re: How to highlight NULL-valued cells in dimension

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

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

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

Not applicable

Re: How to highlight NULL-valued cells in dimension

See project attached.

You can select someting in field Curr.

Re: How to highlight NULL-valued cells in dimension

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.

Not applicable

Re: How to highlight NULL-valued cells in dimension

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.

Community Browser