topic Re: Set Analysis with WeekNo and Positive Margin in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501130#M187259 <HTML><HEAD></HEAD><BODY><P>What is wrong in below expression?</P><P></P><P>=SUM({$&lt;Profit = {"&gt;0%"}, Week = {"&lt;=$(Week(Today()-7")} &gt;}InvoiceAmount)</P></BODY></HTML> Mon, 24 Jun 2013 10:55:38 GMT MK_QSL 2013-06-24T10:55:38Z Set Analysis with WeekNo and Positive Margin https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501129#M187258 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12.0pt; font-family: 'Calibri','sans-serif';">Want to show sale for last 10 weeks….</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Calibri','sans-serif';">Where %Profit should be &gt; 0%.</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Calibri','sans-serif';">Document Date is the date...<BR /></SPAN></P><P></P><P><SPAN style="font-size: 12.0pt; font-family: 'Calibri','sans-serif';">Please help....<BR /></SPAN></P></BODY></HTML> Mon, 24 Jun 2013 10:33:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501129#M187258 MK_QSL 2013-06-24T10:33:44Z Re: Set Analysis with WeekNo and Positive Margin https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501130#M187259 <HTML><HEAD></HEAD><BODY><P>What is wrong in below expression?</P><P></P><P>=SUM({$&lt;Profit = {"&gt;0%"}, Week = {"&lt;=$(Week(Today()-7")} &gt;}InvoiceAmount)</P></BODY></HTML> Mon, 24 Jun 2013 10:55:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501130#M187259 MK_QSL 2013-06-24T10:55:38Z Re: Set Analysis with WeekNo and Positive Margin https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501131#M187260 <HTML><HEAD></HEAD><BODY><P>Is the field Profit really with a %-sign? Isn't that only a number format?</P><P></P><P>So maby </P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=SUM({$&lt;Profit = {"&gt;0"}, Week = {"&lt;=$(Week(Today()-7")} &gt;}InvoiceAmount)</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Mon, 24 Jun 2013 11:01:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501131#M187260 2013-06-24T11:01:51Z Re: Set Analysis with WeekNo and Positive Margin https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501132#M187261 <HTML><HEAD></HEAD><BODY><P>I am receiving an error....!!!</P></BODY></HTML> Mon, 24 Jun 2013 11:45:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501132#M187261 MK_QSL 2013-06-24T11:45:36Z Re: Set Analysis with WeekNo and Positive Margin https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501133#M187262 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What error you are getting?</P><P></P><P>try the below expression if you are having profit in real number format..</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=SUM({$&lt;Profit -= {0}, Week = {"&lt;=$(Week(Today()-7")} &gt;}InvoiceAmount)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">HTH</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Sushil<BR /></SPAN></P></BODY></HTML> Mon, 24 Jun 2013 12:04:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-WeekNo-and-Positive-Margin/m-p/501133#M187262 sushil353 2013-06-24T12:04:22Z