topic Re: Gauge Display Problem. in QlikView

Gauge Display Problem.

Fri, 28 Oct 2011 12:42:57 GMT

I have a query which may return no results as below:

LOAD Count(ProductID) as Critical

Resident Product

WHERE UnitsInStock <ReorderLevel

I display the Critical on a Gauge (Led) and when no result return from the query the Gauge dissaperas where I would like to show the number 0.

Also I tried to show the result of Critical on a Listbox to check if it is null or not nothing came up,

Briefly my question is; how can I show the result as 0 when there is no results?

Thanks

Max

swuehl — Fri, 28 Oct 2011 12:56:59 GMT

Maybe just append something like this to your script after your query (Result is your table name, change it to your given table name):

if( NoOfRows('Result') ) = 0 then

LOAD * INLINE [

Critical

];

end if

Hope this helps,

Stefan

Fri, 28 Oct 2011 13:06:22 GMT

Could you try ensuring 0 is returned rather than null?

 if(isnull(Count(ProductID)),0,Count(ProductID)) AS Critical

James