topic Re: SetAnalysis Query. in QlikView https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797642#M1021503 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try this:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({&lt;[Item Category]={<SPAN style="color: #339966;">'UsedCars'</SPAN>}, [Division] ={50}, [Partner_Func] ={<SPAN style="color: #008000;">'ZS'</SPAN>}&gt;}&nbsp; [Order qty])</SPAN></P></BODY></HTML> Thu, 26 Mar 2015 09:55:43 GMT robert_mika 2015-03-26T09:55:43Z SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797641#M1021502 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is this Correct expression ? </P><P>I just need to sum of Order qty based on Item Category = UsedCars &amp; <SPAN style="font-size: 13.3333330154419px;">Division =50 &amp; <SPAN style="font-size: 13.3333330154419px;">Partner_Func =ZS.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">How to acheive this. I tried the below expression its not working. <BR /></SPAN></P><P></P><P></P><P>sum({&lt;[Item Category]={UsedCars}, [Division] ={50}, [Partner_Func] ={ZS}&gt;}&nbsp; [Order qty])</P></BODY></HTML> Thu, 26 Mar 2015 09:53:19 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797641#M1021502 2015-03-26T09:53:19Z Re: SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797642#M1021503 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try this:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({&lt;[Item Category]={<SPAN style="color: #339966;">'UsedCars'</SPAN>}, [Division] ={50}, [Partner_Func] ={<SPAN style="color: #008000;">'ZS'</SPAN>}&gt;}&nbsp; [Order qty])</SPAN></P></BODY></HTML> Thu, 26 Mar 2015 09:55:43 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797642#M1021503 robert_mika 2015-03-26T09:55:43Z Re: SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797643#M1021504 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>sum({&lt;[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}&gt;}&nbsp; [Order qty])</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Thu, 26 Mar 2015 09:55:46 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797643#M1021504 sushil353 2015-03-26T09:55:46Z Re: SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797644#M1021505 <HTML><HEAD></HEAD><BODY><P>Try using ' for string values</P><P>sum({&lt;[Item Category]=<STRONG>{'UsedCars'}</STRONG>, [Division] ={50}, [Partner_Func] =<STRONG>{'ZS'}</STRONG>&gt;}&nbsp; [Order qty])</P></BODY></HTML> Thu, 26 Mar 2015 09:56:34 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797644#M1021505 sudeepkm 2015-03-26T09:56:34Z Re: SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797645#M1021506 <HTML><HEAD></HEAD><BODY><P>hai can any one explain what is setanalysis?</P></BODY></HTML> Wed, 19 Aug 2015 15:20:02 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797645#M1021506 2015-08-19T15:20:02Z Re: SetAnalysis Query. https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797646#M1021507 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P><P><A href="https://community.qlik.com/thread/59055">Learning Set Analysis from Scratch</A></P><P><A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(18 articles)</A></P></BODY></HTML> Wed, 19 Aug 2015 16:00:36 GMT https://community.qlik.com/t5/QlikView/SetAnalysis-Query/m-p/797646#M1021507 robert_mika 2015-08-19T16:00:36Z