topic Re: multiple AND condition in set analysis in QlikView

multiple AND condition in set analysis

Anonymous — Mon, 02 Jun 2014 07:45:04 GMT

Find the value invoice processed between dates

When I am apply this formula “=Count(distinct if((TransDate>='01/01/2008')and (TransDate<='11/15/2008'), [Invoice
Number]))” am getting value 27726.

When apply same in set analysis concept I did not get same value count({1<TransDate={'>=01/01/2008'},TransDate={'<=11/15/2008'}>} DISTINCT [Invoice
Number]).

Please help me on this . Can you send some example on how to use multiple ‘AND’ condition in set analysis

Re: multiple AND condition in set analysis

tresB — Mon, 02 Jun 2014 07:48:30 GMT

Try like:

count({1<TransDate={'>=01/01/2008 <=11/15/2008'}>} DISTINCT [Invoice
Number]).

Re: multiple AND condition in set analysis

Anonymous — Mon, 02 Jun 2014 08:19:34 GMT

HI Tresesco

It working perfect. Thank you for your prompt reply.

Re: multiple AND condition in set analysis

rohan_mulay — Mon, 30 Jun 2014 06:47:03 GMT

Hi tresesco,

We have a scenario where we want sum of Referrals for those Employees where City is 'mumbai' as well as 'pune'.

Referrals, Employee, City

1, abc, mumbai

2, pqr, pune

1, lmn, mumbai

4, xyz, banglore

5, abc, pune

Re: multiple AND condition in set analysis

jonathandienst — Mon, 30 Jun 2014 06:50:59 GMT

This is a new query. I suggest that you start a new thread as this on has already been answered.