topic Aggr and Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248757#M395530 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I have a formula that is working fine.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance)) </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But I want to achieve the same using set Analysis.</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Please Help How can I do This?</SPAN></P></BODY></HTML> Wed, 08 Mar 2017 06:31:43 GMT mukesh31rathod 2017-03-08T06:31:43Z Aggr and Set Analysis https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248757#M395530 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I have a formula that is working fine.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance)) </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But I want to achieve the same using set Analysis.</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Please Help How can I do This?</SPAN></P></BODY></HTML> Wed, 08 Mar 2017 06:31:43 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248757#M395530 mukesh31rathod 2017-03-08T06:31:43Z Re: Aggr and Set Analysis https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248758#M395531 <HTML><HEAD></HEAD><BODY><P>It will happen from here <A href="https://community.qlik.com/message/1226863">Convert to set analysis</A></P></BODY></HTML> Wed, 08 Mar 2017 10:12:55 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248758#M395531 Anil_Babu_Samineni 2017-03-08T10:12:55Z Re: Aggr and Set Analysis https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248759#M395532 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Thanks for the help.</P><P>I tried using that logic but its not giving me the value.</P></BODY></HTML> Wed, 08 Mar 2017 10:42:17 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248759#M395532 mukesh31rathod 2017-03-08T10:42:17Z Re: Aggr and Set Analysis https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248760#M395533 <HTML><HEAD></HEAD><BODY><P>Please don't create duplicate threads for the same question.</P><P>Instead, try to provide more information, e.g. using a small sample QVW, to the original thread.</P><P></P><P>You already got some help and attention in your original thread.</P></BODY></HTML> Wed, 08 Mar 2017 12:41:13 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Set-Analysis/m-p/1248760#M395533 swuehl 2017-03-08T12:41:13Z