Set analysis expression logically same but giving different results

[mallikarjun_h]

Hi ,

I have written 2 expression which will count ticket ID.

attaching QVW file for reference.

Can anyone let me know why & how these expressions are giving different results?

Thanks.

[sunny_talwar]

Because your 1st expression missed a part:

=Count({$<Type={'Accepted Lead'},ProductId={'*'}-{5}>+<Type={'Instructed Lead'},ProductId={'*'}-{5}>}TicketId)

[mallikarjun_h]

Hi Sunny,

Thanks for the information.

I had written ProductId={'*'}-{5} in 1st expression at the end.

Why it is not considering what I have written after coma in set modifier?

[sunny_talwar · Accepted solution]

They are two different sets <>+<> and both needs that same condition in order to become comparable to the second expression.

[mallikarjun_h]

Thanks I got it