topic Reg:Null in Set Analysis in QlikView

Reg:Null in Set Analysis

Tue, 02 Nov 2010 09:12:10 GMT

Hi All,

In set analysis how to mention the null() function in expression.

For Ex:

The expression like Sum(if(Req_Qty >0,Req_Qty ,null())

I would like to replicate this in set analysis.if any one know share with me the same

Thanks & Regards

Jai

Tue, 02 Nov 2010 09:54:34 GMT

If you do not specify a value for a 'then' or 'else' in a condition then null is returned.

For example

if(Req_Qty >0,Req_Qty )

then where Req_Qty is not >0 then null is returned.

Logically though when using an aggregation function (SUM) you would want to return 0 rather than null anyway.

Regards,

Gordon

Tue, 02 Nov 2010 10:08:17 GMT

Hi,

In this case I will get '0' values for qty <0,But I want to show null in table.Basically I dont want to show '0' values

Thanks & Regards

Jai

Tue, 02 Nov 2010 10:16:00 GMT

If you dont want to see those dimensions which have zero values for their expressions, see Chart Properties > Presentation > Suppress Zero Values

Regards,

Gordon