Removing NULL Values from Straight Chart

[#1]

Hi,

I am new to Qlikview, however with help from this forum, I managed to create a Straight chart which has all values from of all issues raised from a database (which used SQL to input).  However there is a field called closedby, which is populated with a username of the person who has resolved the issue.  However if the issue has not been resolved is shows as NULL, if the issue has been resolved but was reopened it shows as Blank.

Would someone be able to let me know how I can remove the NULL and Blank values from this chart.  If there is a code for this, would you also be able to advised where this need to go please?

Regards,

Jon Ditchfield

[rajni_batra · Accepted solution]

In Dimension and Presentation Tab Check Supress Null Values / Supress Zero Values resp.

Hope it Helps!!!

[jagan]

Hi,

How many expressions you have in your chart?  If there are multiple expressions then you have to make 0 to all other columns, then only entire row will be removed.

Can you attach a sample file which you are working, it helps in understanding the Dimensions and Expressions used in the chart. 

Regards,

Jagan.