Discussion board where members can get started with QlikView.
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 ?
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.
I wouldnt actually have an Expression for it to be a straight table , do you have any idea of a work around for this ?
I did put a random experssion and it still isnt hiding Nulls , I reckon it need to be amended in Script
I see what you mean. You are right.
Did you try this for the other tabels aswell?
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 !!)