topic Re: Background colours for 'Missing / Null' cells in QlikView

Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:25:59 GMT

Hi All,

In the Pivot Table background coloring,the expression defining the color is an attribute expression, and it will only be calculated if the main expression is calculated. Coloring will not be applied if the first column result is missing or null values. Can give a work round for the same.

Thanks

Santahrubban

Re: Background colours for 'Missing / Null' cells

sunny_talwar — Thu, 15 Sep 2016 13:28:47 GMT

Try to check 'Suppress Zero Values' on the presentation tab.

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:30:17 GMT

I need to show zero values too

Re: Background colours for 'Missing / Null' cells

tracysmart — Thu, 15 Sep 2016 13:41:13 GMT

you can set it on the attribute of the dimension to background colour those that are null

=if(isnull(MyDimension), RGB(255,255,255))

or if its a null expression - you can do it on the attribute of the expression

=if(isnull(MyExpression), RGB(255,255,255))

changing the RGB to your colour

Hope that helps

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:44:03 GMT

Thanks Tracy.

But it doesn't work, I have already tried.

Re: Background colours for 'Missing / Null' cells

sunny_talwar — Thu, 15 Sep 2016 13:45:07 GMT

Can you share a sample application where we can see this issue? Doesn't have to be your actually application, may be just mock up some data to show what you are seeing?

Re: Background colours for 'Missing / Null' cells

Anil_Babu_Samineni — Thu, 15 Sep 2016 13:46:22 GMT

If(expression = '0' or expression = 'null' , red())

This expression would write expression BG color

Re: Background colours for 'Missing / Null' cells

jpenuliar — Thu, 15 Sep 2016 13:49:17 GMT

you can set Background Colour in "Visual Cues"

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:52:14 GMT

no luck, it doesn't work

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:52:33 GMT

no luck, it doesn't work

Re: Background colours for 'Missing / Null' cells

jpenuliar — Thu, 15 Sep 2016 13:54:37 GMT

Modify the 4th ("Text") Background Color box.

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 13:55:56 GMT

Hi Sunny,

I can't upload application, i have attached screen print of issues

Re: Background colours for 'Missing / Null' cells

Anil_Babu_Samineni — Thu, 15 Sep 2016 14:03:57 GMT

If you have only zero then try this

If(isnull(expression) <= 0 , red())

Re: Background colours for 'Missing / Null' cells

neelamsaroha157 — Thu, 15 Sep 2016 14:08:15 GMT

Try if(Your_Expression >0 and len(Your_Expression) >0 , RGB(0,255,0) , RGB(255,0,0))

Re: Background colours for 'Missing / Null' cells

florentina_doga — Thu, 15 Sep 2016 14:09:54 GMT

see attach pls

Re: Background colours for 'Missing / Null' cells

trdandamudi — Thu, 15 Sep 2016 14:23:39 GMT

Are you looking for something like below:

Re: Background colours for 'Missing / Null' cells

santharubban — Thu, 15 Sep 2016 14:48:58 GMT

highlighted yellow line should in white line, but its showing grey clor.