topic Re: Set analysis exclude! in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642271#M235280 <HTML><HEAD></HEAD><BODY><P>Still it is same..!</P></BODY></HTML> Wed, 21 May 2014 18:19:21 GMT 2014-05-21T18:19:21Z Set analysis exclude! https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642268#M235277 <HTML><HEAD></HEAD><BODY><P>Can anyone explain me what's wrong in this expression, once I added the exclude script rest of the expression changing from default colors (black red green) to black. But expression window shows me expression is ok.</P><P>((</P><P>Sum( {$&lt;Year={$(v)},SalesType={'Gross'}&gt;} SalesAmt)</P><P>+ Sum({$&lt;Year={$(v)},SalesType={'WOff'}, <SPAN style="color: #ff0000;">SaleWOType -= {bad_debt}</SPAN>&gt;} SaleWOAmount)</P><P>&nbsp; + Sum( {$&lt;Year={$(v)},SalesType={'Fee'}&gt;} SalesAmt)</P><P>&nbsp; - Sum( {$&lt;Year={$(v)},SalesType={'Returned'}&gt;} SalesAmt)</P><P> <SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">))</SPAN></P></BODY></HTML> Wed, 21 May 2014 16:12:47 GMT https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642268#M235277 2014-05-21T16:12:47Z Re: Set analysis exclude! https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642269#M235278 <HTML><HEAD></HEAD><BODY><P>Syntax checker is not perfect. Test your expression and see if it returns the correct result.</P></BODY></HTML> Wed, 21 May 2014 16:15:51 GMT https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642269#M235278 luciancotea 2014-05-21T16:15:51Z Re: Set analysis exclude! https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642270#M235279 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">((</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum( {$&lt;Year={$(v)},SalesType={'Gross'}&gt;} SalesAmt)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+ Sum({$&lt;Year={$(v)},SalesType={'WOff'}, <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">SaleWOType -= {'bad_debt'}</SPAN>&gt;} SaleWOAmount)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp; + Sum( {$&lt;Year={$(v)},SalesType={'Fee'}&gt;} SalesAmt)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp; - Sum( {$&lt;Year={$(v)},SalesType={'Returned'}&gt;} SalesAmt)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">))</SPAN></P></BODY></HTML> Wed, 21 May 2014 16:18:27 GMT https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642270#M235279 venkatg6759 2014-05-21T16:18:27Z Re: Set analysis exclude! https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642271#M235280 <HTML><HEAD></HEAD><BODY><P>Still it is same..!</P></BODY></HTML> Wed, 21 May 2014 18:19:21 GMT https://community.qlik.com/t5/QlikView/Set-analysis-exclude/m-p/642271#M235280 2014-05-21T18:19:21Z