topic Re: Set Analysis with and condition in QlikView

Set Analysis with and condition

manishapanda1 — Sat, 20 Jul 2019 19:03:33 GMT

Hello friends, Can some one please help to solve this : how to get sales person name who did sales for the both India and Uk through set analysis only. for ex: sales executive country sales jaya India 100 hema India 200 rekha Uk 200 sita Canada 1000 Thanks, Manisha Panda

Re: Set Analysis with and condition

trdandamudi — Sat, 20 Jul 2019 19:57:19 GMT

See the below expression and also attached a sample. Hope this helps:

=Sum({<Name=p({<Country={'India'}>}) * p({<Country={'UK'}>})>} Sales)

Re: Set Analysis with and condition

manishapanda1 — Wed, 14 Aug 2019 03:47:51 GMT

Thank you