Set analysis for AND

[#1]

count( if(not isnull(MinNoAfterFirstYes) and not isnull(MinFirstYes),if(Audit_Date>=Date_Master_From and Audit_Date<=Date_Master_To,CallID)))

How can i write it in set analysis method.....Please help....

[CELAMBARASAN]

You can achieve this using intersection operator.

Count({<MinNoAfterFirstYes={*}>}*{<MinFirstYes={*}>}*{<Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"}>} CallID)

[#3]

everything looking gud but its missing not null in above expression. How to use add that.

[CELAMBARASAN]

={*} is to return the non null values.

[#5]

The expression provided by you is not working....Shows red lines in expression window of any chart object. Syntax error kind of thing.

[teempi]

Hello,

I don't think that {*} calculates null values because nulls cannot be selected. I would probably create a flag into the data that tells you if a certain field is null. Then you can use the flag to include those null rows.

-Teemu

[#7]

Can you please provide me the syntax by assuming flag. Anyway I wil create flag. After that what will be the syntax for above expression which I have posted above....?

Please help.

[#8]

Can you please provide me the syntax by assuming flag. Anyway I wil create flag. After that what will be the syntax for above expression which I have posted above....?

Please help.

[CELAMBARASAN]

What this means?

not isnull(MinNoAfterFirstYes)

Your trying to retrieve non null values. right?

It doesn't select null values it will select non null values..

[#10]

I am talikng about this expression. It is not working. Shows syntax error when i put in expr

ession window. Can you provide me right syntax.

I tried by changing here and there but not worked. So please suggest.

Count({<MinNoAfterFirstYes={*}>}*{<MinFirstYes={*}>}*{<Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"}>} CallID)