topic Re: Set analysis involving &lt;&gt; in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456500#M490233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P></P><P>=(Sum({&lt;DAYS_LATE={'&gt;1'}&gt;} PRINC_BALANCE)/sum(PRINC_BALANCE)) * 100</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 01 Oct 2012 10:36:28 GMT jagan 2012-10-01T10:36:28Z Set analysis involving <> https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456499#M490232 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Could there be an ideal and better way to re-write this expression below because i can't get my head around is using set analysis. </P><P></P><P>sum(if(DAYS_LATE&gt;1,PRINC_BALANCE))/sum(PRINC_BALANCE)*100</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 01 Oct 2012 10:31:32 GMT https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456499#M490232 Anonymous 2012-10-01T10:31:32Z Re: Set analysis involving <> https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456500#M490233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P></P><P>=(Sum({&lt;DAYS_LATE={'&gt;1'}&gt;} PRINC_BALANCE)/sum(PRINC_BALANCE)) * 100</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 01 Oct 2012 10:36:28 GMT https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456500#M490233 jagan 2012-10-01T10:36:28Z Re: Set analysis involving <> https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456501#M490234 <HTML><HEAD></HEAD><BODY><P>Awesome! thanks Jagan</P></BODY></HTML> Mon, 01 Oct 2012 11:51:07 GMT https://community.qlik.com/t5/QlikView/Set-analysis-involving-lt-gt/m-p/456501#M490234 Anonymous 2012-10-01T11:51:07Z