topic If statement to Set analysis in QlikView https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428922#M486459 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>i want to convert this if statement to set analysis.</P><P></P><P></P><P>sum <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Jahr</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">()) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Warenfamilie</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt; 30 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UA' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'DI' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UÄ' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UT'), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Umsatz</SPAN><SPAN style="font-size: 8pt;">, 0))&nbsp;&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I hope anybody can help me.</SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 11 Mar 2013 14:59:20 GMT 2013-03-11T14:59:20Z If statement to Set analysis https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428922#M486459 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>i want to convert this if statement to set analysis.</P><P></P><P></P><P>sum <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Jahr</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">()) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Warenfamilie</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt; 30 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UA' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'DI' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UÄ' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">UrsprungsAuftragstyp</SPAN><SPAN style="font-size: 8pt;"> = 'UT'), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Umsatz</SPAN><SPAN style="font-size: 8pt;">, 0))&nbsp;&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I hope anybody can help me.</SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 11 Mar 2013 14:59:20 GMT https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428922#M486459 2013-03-11T14:59:20Z Re: If statement to Set analysis https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428923#M486460 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Jahr={'$(=year(today()))'}, Warenfamilie -={30}, UrsprungsAuftragstyp={'UA','DI','UÄ','UT'} &gt;} Umsatz)</P></BODY></HTML> Mon, 11 Mar 2013 15:01:52 GMT https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428923#M486460 Gysbert_Wassenaar 2013-03-11T15:01:52Z Re: If statement to Set analysis https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428924#M486461 <HTML><HEAD></HEAD><BODY><P>It works great!</P><P>Thank you very much <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/gwassenaar" id="jive-9654416394182531982920" onmouseout="" onmouseover="">Gysbert Wassenaar</A> for the quick answere! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 11 Mar 2013 15:08:13 GMT https://community.qlik.com/t5/QlikView/If-statement-to-Set-analysis/m-p/428924#M486461 2013-03-11T15:08:13Z