topic Alternate state in set analysis in QlikView https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905530#M314716 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am facing a problem ...</P><P></P><P>I have 2 dimensions dimension 1.@_customer_Name&nbsp; 2.@_Item_Name&nbsp; measure is #_netsales</P><P><SPAN style="font-size: 13.3333330154419px;">I have created 2 alternate state groups 1.Group1&nbsp; 2. Group2&nbsp; considering the </SPAN><SPAN style="font-size: 13.3333330154419px;">@_Item_Name dimensions.</SPAN></P><P>I want to display a straight table where I want to display "<STRONG>the customer wise </STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>#_netsales who didn't purchase any items from the @_item_Name listbox which is of&nbsp; Alternate state - Group2"?</STRONG></SPAN></P><P></P><P>Can anyone please help me?</P></BODY></HTML> Mon, 27 Apr 2015 09:41:44 GMT 2015-04-27T09:41:44Z Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905530#M314716 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am facing a problem ...</P><P></P><P>I have 2 dimensions dimension 1.@_customer_Name&nbsp; 2.@_Item_Name&nbsp; measure is #_netsales</P><P><SPAN style="font-size: 13.3333330154419px;">I have created 2 alternate state groups 1.Group1&nbsp; 2. Group2&nbsp; considering the </SPAN><SPAN style="font-size: 13.3333330154419px;">@_Item_Name dimensions.</SPAN></P><P>I want to display a straight table where I want to display "<STRONG>the customer wise </STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>#_netsales who didn't purchase any items from the @_item_Name listbox which is of&nbsp; Alternate state - Group2"?</STRONG></SPAN></P><P></P><P>Can anyone please help me?</P></BODY></HTML> Mon, 27 Apr 2015 09:41:44 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905530#M314716 2015-04-27T09:41:44Z Re: Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905531#M314717 <HTML><HEAD></HEAD><BODY><P>Dimention : Customer</P><P>Expession : =Sum({Group2&lt;<STRONG style="font-size: 13.3333320617676px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">@_item_Name=Null()</STRONG>&gt;}#_netSales)</P></BODY></HTML> Mon, 27 Apr 2015 09:46:48 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905531#M314717 2015-04-27T09:46:48Z Re: Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905532#M314718 <HTML><HEAD></HEAD><BODY><P>My guess would be sum({&lt;@_item_Name=e({Group2}@_item_Name)&gt;} #_netsales)</P></BODY></HTML> Mon, 27 Apr 2015 09:49:24 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905532#M314718 Gysbert_Wassenaar 2015-04-27T09:49:24Z Re: Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905533#M314719 <HTML><HEAD></HEAD><BODY><P>no.It's giving syntax error.</P></BODY></HTML> Mon, 27 Apr 2015 09:52:49 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905533#M314719 2015-04-27T09:52:49Z Re: Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905534#M314720 <HTML><HEAD></HEAD><BODY><P>Can u provide some sample data ...</P></BODY></HTML> Mon, 27 Apr 2015 09:57:53 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905534#M314720 2015-04-27T09:57:53Z Re: Alternate state in set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905535#M314721 <HTML><HEAD></HEAD><BODY><P>Thanks a lot for your help.Working as expected.</P></BODY></HTML> Mon, 27 Apr 2015 12:36:40 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-set-analysis/m-p/905535#M314721 2015-04-27T12:36:40Z