topic Re:Next in QlikView https://community.qlik.com/t5/QlikView/Re-Next/m-p/896427#M530637 <HTML><HEAD></HEAD><BODY><P>SUM(Aggr(IF(If((sum(NUMERATOR)/sum(DENOMINATOR))&gt;=PtileBeg and (sum(NUMERATOR)/sum(DENOMINATOR))&lt;=PtileEnd,Star)=1,sum(DENOMINATOR) * $(vStar)-sum(NUMERATOR)),MEASURE_ID,Star))</P></BODY></HTML> Tue, 07 Jul 2015 09:29:18 GMT MK_QSL 2015-07-07T09:29:18Z Re:Next https://community.qlik.com/t5/QlikView/Re-Next/m-p/896426#M530636 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>PFA</P><P></P><P>my requiremnt is to get the minimum passes</P><P>and find the attched image for exact output.</P><P></P><P>Thank you</P><P></P><P>Suresh !</P></BODY></HTML> Tue, 07 Jul 2015 09:07:57 GMT https://community.qlik.com/t5/QlikView/Re-Next/m-p/896426#M530636 Chanty4u 2015-07-07T09:07:57Z Re:Next https://community.qlik.com/t5/QlikView/Re-Next/m-p/896427#M530637 <HTML><HEAD></HEAD><BODY><P>SUM(Aggr(IF(If((sum(NUMERATOR)/sum(DENOMINATOR))&gt;=PtileBeg and (sum(NUMERATOR)/sum(DENOMINATOR))&lt;=PtileEnd,Star)=1,sum(DENOMINATOR) * $(vStar)-sum(NUMERATOR)),MEASURE_ID,Star))</P></BODY></HTML> Tue, 07 Jul 2015 09:29:18 GMT https://community.qlik.com/t5/QlikView/Re-Next/m-p/896427#M530637 MK_QSL 2015-07-07T09:29:18Z Re:Next https://community.qlik.com/t5/QlikView/Re-Next/m-p/896428#M530638 <HTML><HEAD></HEAD><BODY><P>hi Manish,</P><P></P><P>thanx for uaa replay am not getting the result</P><P></P><P>can u help me othe qvw and try t get the&nbsp; output bro..</P><P></P><P>i tried like dis&nbsp; am attchng the expression hope that exp wil helps you</P><P></P><P>Thank u</P><P></P><P>Suresh</P></BODY></HTML> Tue, 07 Jul 2015 15:32:21 GMT https://community.qlik.com/t5/QlikView/Re-Next/m-p/896428#M530638 Chanty4u 2015-07-07T15:32:21Z