topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/819275#M1045481 <HTML><HEAD></HEAD><BODY><P><STRONG>hi Friends/Experts,</STRONG></P><P></P><P><STRONG>need set analysis expression for comparing 4 columns like</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><SPAN style="text-decoration: underline;">Tab 1:-&nbsp; </SPAN>1)item_no,2)item_name 3)Item_Rank </STRONG></P><P></P><P><STRONG><SPAN style="text-decoration: underline;">Tab2:- </SPAN> 1)item_num,2)item_naming 3)Item_Rank 4)item_cost</STRONG></P><P></P><P><STRONG>now i want expression for&nbsp; </STRONG></P><P><STRONG>sum(item_cost) where item_no=item_num &amp; item_name=item_naming</STRONG></P><P><STRONG>aggr(if((item_no=item_num and item_name=item_naming),sum(item_cost)) , ( item_Rank))</STRONG></P></BODY></HTML> Tue, 25 Nov 2014 16:42:07 GMT ramasaisaksoft 2014-11-25T16:42:07Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/819275#M1045481 <HTML><HEAD></HEAD><BODY><P><STRONG>hi Friends/Experts,</STRONG></P><P></P><P><STRONG>need set analysis expression for comparing 4 columns like</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><SPAN style="text-decoration: underline;">Tab 1:-&nbsp; </SPAN>1)item_no,2)item_name 3)Item_Rank </STRONG></P><P></P><P><STRONG><SPAN style="text-decoration: underline;">Tab2:- </SPAN> 1)item_num,2)item_naming 3)Item_Rank 4)item_cost</STRONG></P><P></P><P><STRONG>now i want expression for&nbsp; </STRONG></P><P><STRONG>sum(item_cost) where item_no=item_num &amp; item_name=item_naming</STRONG></P><P><STRONG>aggr(if((item_no=item_num and item_name=item_naming),sum(item_cost)) , ( item_Rank))</STRONG></P></BODY></HTML> Tue, 25 Nov 2014 16:42:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/819275#M1045481 ramasaisaksoft 2014-11-25T16:42:07Z