topic Re: Set analysis not working like it should in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-not-working-like-it-should/m-p/290249#M495963 <HTML><HEAD></HEAD><BODY><P> hi </P><P>in this case you cant use set analysis because it select one type so in the other types it gives you null</P><P>check the attach file </P><P>i changed the expression to if clause</P></BODY></HTML> Thu, 16 Feb 2012 18:45:05 GMT lironbaram 2012-02-16T18:45:05Z Set analysis not working like it should https://community.qlik.com/t5/QlikView/Set-analysis-not-working-like-it-should/m-p/290248#M495962 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Can someone explain my why adding the TYPE in the pivot table makes the formula below not work anymore.</P><P></P><P>Sum({$&lt;TYPE={"Dmtthjs"}&gt;} [Sal Serv Other])</P><P></P><P></P><P>Can anyone help me to get it to work again?</P><P></P><P>The idea is that I can reuse the value of TYPE='Dmtthjs' for the other values of TYPE.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="148"><TBODY><TR><TD class="xl63" height="17" width="148">Yqtqanj</TD></TR><TR><TD class="xl64" height="17">Dmtthjs</TD></TR><TR><TD class="xl63" height="17">Sxrddvf</TD></TR></TBODY></TABLE><P></P><P>Kind Regards,</P><P></P><P>Dion</P></BODY></HTML> Thu, 16 Feb 2012 15:35:47 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-working-like-it-should/m-p/290248#M495962 2012-02-16T15:35:47Z Re: Set analysis not working like it should https://community.qlik.com/t5/QlikView/Set-analysis-not-working-like-it-should/m-p/290249#M495963 <HTML><HEAD></HEAD><BODY><P> hi </P><P>in this case you cant use set analysis because it select one type so in the other types it gives you null</P><P>check the attach file </P><P>i changed the expression to if clause</P></BODY></HTML> Thu, 16 Feb 2012 18:45:05 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-working-like-it-should/m-p/290249#M495963 lironbaram 2012-02-16T18:45:05Z