topic Re: Set analysis expression logically same but giving different results in QlikView

Set analysis expression logically same but giving different results

mallikarjun_h — Tue, 09 Aug 2016 10:23:12 GMT

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 — Tue, 09 Aug 2016 10:27:55 GMT

Because your 1st expression missed a part:

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

mallikarjun_h — Tue, 09 Aug 2016 11:38:03 GMT

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 — Tue, 09 Aug 2016 11:40:30 GMT

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

mallikarjun_h — Tue, 09 Aug 2016 11:54:14 GMT

Thanks I got it