Set analysis filtering Issue ?

veeranj — Mon, 07 May 2018 07:06:15 GMT

Hi All ,

I have data as below :

If Desc is null,i am counting

load cust,if(len(trim(desc))=0,null(),desc) as desc;

LOAD * INLINE [

cust,desc

c1,

];

I have to count the below expression :

Count({<desc={'pureatgrp'}>}cust) -- it is giving output as 2, but there are no desc having desc='pureatgrp' .

Not sure of why it is behaving like this .

Thanks,

Veera

Re: Set analysis filtering Issue ?

tresB — Mon, 07 May 2018 07:32:07 GMT

Please don't create duplicate threads. This is being discussed here: Re: Set analysis filtering Issue ?