topic Table Box shows null values in QlikView

Table Box shows null values

Thu, 12 Jan 2012 09:24:40 GMT

Hi Guys

I have the above table box, I have it checked on the Presentation to "OMIT when values are Null" For Region Name , NewCoins and then Ive tried different combinations of each if the empty columns.

I still am getting all that empty rows.

Can any advise how I may get rid of them ?

Thanks

Anne

Table Box shows null values

Thu, 12 Jan 2012 09:31:20 GMT

Table Box shows null values

Anonymous — Thu, 12 Jan 2012 09:33:09 GMT

I don't think that is possible in a tablebox (not unless you filter your data in the script)
I would suggest to try a straight table.

Table Box shows null values

Thu, 12 Jan 2012 09:42:25 GMT

Hi Dennis

I wouldnt actually have an Expression for it to be a straight table , do you have any idea of a work around for this ?

Thanks

Table Box shows null values

Thu, 12 Jan 2012 09:45:58 GMT

Actually Dennis

I did put a random experssion and it still isnt hiding Nulls , I reckon it need to be amended in Script

Thanks

Table Box shows null values

Anonymous — Thu, 12 Jan 2012 11:12:53 GMT

I see what you mean. You are right.

Did you try this for the other tabels aswell?

Table Box shows null values

Thu, 12 Jan 2012 11:35:35 GMT

Hi Dennis

Ive used this Omit values Null before and it has always worked as I have expected.

But These loads are quite different than the way I normally do things, Im going to amend the script to something like

if([Parent Branch]=' ',null(),[Parent Branch]) as Branch

Then hopefully it will recognise the Blanks as NULL so the check in the Chart should work !!

( I hope !!)

Thanks