topic Re: Excluded null values in QlikView

Excluded null values

Anonymous — Wed, 12 Nov 2014 06:58:12 GMT

Hi..

In set analysis how we excluded null values for perticular field..

Please Help me..

Thanks,

Re: Excluded null values

ashfaq_haseeb — Wed, 12 Nov 2014 07:02:43 GMT

Hi,

Filtering Null is a tricky part.

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

If possible share sample app to look over.

Regards

ASHFAQ

Re: Excluded null values

Wed, 12 Nov 2014 07:05:00 GMT

eg: to exclude null values

sum({<status -= {''}>}sales)

sum({<status = {'*'}-{''}>}sales)

Re: Excluded null values

Wed, 12 Nov 2014 07:08:57 GMT

sum({<resoveddate-={''}>}sales)

Re: Excluded null values

MK_QSL — Wed, 12 Nov 2014 07:16:40 GMT

Consider that you have sales data with Customer, Date and Sales as Fields and Date field is having Null Values... You can find Total Sales wherever Date is not null as below

SUM({<Date = {'*'}>}Sales)

If the above is not working, you need to assign blank or - values of Date as Null.

Use below code in Script which will replace Date

IF(IsNull(Date) or Len(Trim(Replace(Date,'-','')))=0,Null(),Date) as Date