topic Line Chart Show Zero Values but not NULL Values in QlikView

Line Chart Show Zero Values but not NULL Values

dselgo_eidex — Fri, 29 Jan 2016 19:36:33 GMT

Hello, I'm currently working on a chart that will show dropout rates for schools. The problem that I am having is the school's dropout rate can either be 0 (no dropouts) or NULL (no record). My dimensions are according to Year and then School Name in that order. The Set Analysis works where it only calculates the dropout rate for schools within a specified district. This results in the schools within the district calculating dropout rates, while every other school's dropout rates become NULL. This is what I want, but the problem is that I need to show when the dropout rate is 0, and when I uncheck "Suppress Zero Values" I get the zero values for the schools in the district, but my chart also shows every other school. So my question is if there is a way to only suppress the NULL values? "Suppress Missing" does not work, neither does "Suppress when value is null" on the dimension tab. I'll attach some pictures to give you an idea.

Re: Line Chart Show Zero Values but not NULL Values

dselgo_eidex — Mon, 01 Feb 2016 14:28:21 GMT

Bump

Re: Line Chart Show Zero Values but not NULL Values

gsbeaton — Mon, 01 Feb 2016 15:32:30 GMT

Hi Danny,

Nulls in your data will always cause you problems. Best to try to tag with a value which you can work with in the front end.

My suggestion would be to change your nulls in the load script, something like if(isNull(DropOut),-1,DropOut). You don't have to tag with -1, but that's a useful value to work with. In your set analysis, you can then do something like count({<DropOut={'>0'}>}DropOut).

Hope that helps.

Re: Line Chart Show Zero Values but not NULL Values

Peter_Cammaert — Mon, 01 Feb 2016 15:47:34 GMT

A demo document (QVW) with representative data would be very helpful. You can anonymise fields that contain names and IDs. Can you post such a document in this thread?

Re: Line Chart Show Zero Values but not NULL Values

dselgo_eidex — Mon, 01 Feb 2016 20:08:04 GMT

Thanks for the advice. I did that and it's working great now. Thanks for the help!