Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Table Box shows null values

setup.bmp

dennisnet
Not applicable

Table Box shows null values

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

Table Box shows null values

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

Table Box shows null values

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

dennisnet
Not applicable

Table Box shows null values

I see what you mean. You are right.

Did you try this for the other tabels aswell?

Not applicable

Table Box shows null values

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