possible values

[smilingjohn]

Hi All, 

I wanted consider the values by comparing  two fields which i am doing by Possible value in set analysis .

Count({<category=P(SubCat)>}ID).

but this is not considering the exact field match value . Can you please help me in getting the exact field value match 

Thanks in Advance 

[marcus_sommer]

Set analysis does a column-level evaluation. If you need a row-level evaluation you need to use an if-loop, maybe like:

if(category=SubCat, Count(ID))

- Marcus

[smilingjohn]

Thanks for the reply Marcus , 

I am using  the expression is something like this   and tried to implement your logic  as shown below but this doesn't give me any value , can you please suggest me where exactly I am going wrong ? 

if(category=SubCat),
Aggr(
count(Distinct {<STATUS-={'Delivered'},
SEVERITY_NAME={'1 - Critical','2 - High'}>}
if(CREATE_DATE<IntDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=IntDate),ID)),''))

Thanks

[smilingjohn]

Hi Expertise

Any help on my post 

Thanks 

[vinieme12]

The expression is syntactically correct but may be logically incorrect in context of the actual data 

Also I would suggest creating flags in your data for below conditions so you can use the flag fields in your expression

if(CREATE_DATE<IntDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=IntDate),1,0) as flagDateCriteria 

If(category=SubCat,1,0) as flagcategoryCriteria

Then use flags in set analysis as below

count(Distinct {<STATUS-={'Delivered'},

SEVERITY_NAME={'1 - Critical','2 - High'},

flagDateCriteria={1},

flagcategoryCriteria={1}

>} ID)

Please post some sample data 

[marcus_sommer]

IMO the expression is quite wrong - logically and syntactically because of the missing outer aggregation of the aggr(), also the dimension within the aggr() is missing, the first if-loop condition ends with a bracket, ...

I would rather try something like this:

if(CREATE_DATE < IntDate and
   (isnull(CLOSE_DATE) or CLOSE_DATE >= IntDate) and
   category=SubCat,
   count(Distinct {<STATUS-={'Delivered'}, SEVERITY_NAME={'1 - Critical','2 - High'}>} ID)

- Marcus