topic Re: Removing NULL Values from Straight Chart in QlikView

Removing NULL Values from Straight Chart

Mon, 06 Aug 2012 10:09:02 GMT

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

Re: Removing NULL Values from Straight Chart

rajni_batra — Mon, 06 Aug 2012 10:28:34 GMT

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

Hope it Helps!!!

Re: Removing NULL Values from Straight Chart

jagan — Mon, 06 Aug 2012 11:16:14 GMT

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.