topic Re: Re: Unique Attendees in QlikView https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509810#M190518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA,</P><P></P><P>If you will see the data - Apr - Unique is - 417</P><P>and May - 461 but in May month 50 attendees are common which was in april. So Commulative should be for Apr and May - 828</P><P></P><P>Thanks for reply.</P></BODY></HTML> Wed, 23 Oct 2013 07:12:03 GMT 2013-10-23T07:12:03Z Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509808#M190516 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a scenerio like :</P><P></P><P>In my organisation I am conducting training in Apr and No. of Attendees are 200 and In May 150 but 30 are common. Now I want the month wise cummulative, but some Attendees are common in may month and I want the unique no. of Attendees .&nbsp; Output will be like this.</P><P></P><P>Apr - 200</P><P>May - 200+150 = 350 but Unique Attendees are 350 - 30 = 320</P><P></P><P>Simmilarly it will go till current month of this year.</P><P></P><P>Please suggest how to do the same.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 23 Oct 2013 06:38:51 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509808#M190516 2013-10-23T06:38:51Z Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509809#M190517 <HTML><HEAD></HEAD><BODY><P>Please provide some sample data</P></BODY></HTML> Wed, 23 Oct 2013 06:45:01 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509809#M190517 sushil353 2013-10-23T06:45:01Z Re: Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509810#M190518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA,</P><P></P><P>If you will see the data - Apr - Unique is - 417</P><P>and May - 461 but in May month 50 attendees are common which was in april. So Commulative should be for Apr and May - 828</P><P></P><P>Thanks for reply.</P></BODY></HTML> Wed, 23 Oct 2013 07:12:03 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509810#M190518 2013-10-23T07:12:03Z Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509811#M190519 <HTML><HEAD></HEAD><BODY><P>Hi Amit,</P><P></P><P>there should be some attendees id to check who have attending in which month..</P><P></P><P>the data attached here does not have such information... how would you know that in Apr and May 50 attendees were common.</P><P></P><P>~sushil</P></BODY></HTML> Wed, 23 Oct 2013 08:28:28 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509811#M190519 sushil353 2013-10-23T08:28:28Z Re: Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509812#M190520 <HTML><HEAD></HEAD><BODY><P>Please Checkout with this data.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 23 Oct 2013 09:16:38 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509812#M190520 2013-10-23T09:16:38Z Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509813#M190521 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>I do agree with <SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/Sushil353">Sushil353</A> as we should have an key which identifies the common attendees once you found then you can simply subtract that with your expression.</STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG> </STRONG></SPAN></P><DIV class="js-thread-post-wrapper j-rc4 j-thread-post-wrapper jive-content"><DIV class="j-thread-post j-rc4"><DIV class="j-post-avatar"><P></P>&nbsp; <SPAN class="j-post-author">&nbsp; <STRONG>&nbsp;&nbsp; <BR class="active_link jiveTT-hover-user jive-username-link" data-avatarid="4075" data-externalid="" data-presence="null" data-userid="50986" data-username="Sushil353" /></STRONG></SPAN></DIV></DIV></DIV></BODY></HTML> Wed, 23 Oct 2013 09:43:59 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509813#M190521 qlikpahadi07 2013-10-23T09:43:59Z Re: Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509814#M190522 <HTML><HEAD></HEAD><BODY><P>Without sustraction can we write an Aggr Expresion.</P></BODY></HTML> Wed, 23 Oct 2013 09:58:27 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509814#M190522 2013-10-23T09:58:27Z Re: Re: Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509815#M190523 <HTML><HEAD></HEAD><BODY><P>Hi amit,</P><P></P><P>PFA.</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Wed, 23 Oct 2013 10:45:24 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509815#M190523 sushil353 2013-10-23T10:45:24Z Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509816#M190524 <HTML><HEAD></HEAD><BODY><P>Not Working :</P><P></P><P>Communlative work from Apr, Than Apr+May, Then Apr+May+Jun (No. of Attendees).</P><P></P><P>Thanks</P></BODY></HTML> Wed, 23 Oct 2013 13:08:12 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509816#M190524 2013-10-23T13:08:12Z Re: Unique Attendees https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509817#M190525 <HTML><HEAD></HEAD><BODY><P>Hi Amit,</P><P></P><P>Please let me know what is the issue you are getting with example</P><P></P><P>~Sushil</P></BODY></HTML> Wed, 23 Oct 2013 16:48:11 GMT https://community.qlik.com/t5/QlikView/Unique-Attendees/m-p/509817#M190525 sushil353 2013-10-23T16:48:11Z