Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Box shows null values

Chart.bmp

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

6 Replies
Not applicable
Author

setup.bmp

Anonymous
Not applicable
Author

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.

Not applicable
Author

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

A

Not applicable
Author

Actually Dennis

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

Thanks


A

Anonymous
Not applicable
Author

I see what you mean. You are right.

Did you try this for the other tabels aswell?

Not applicable
Author

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

A