topic Re: Need Help with making the expression more granular in QlikView https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784443#M1035006 <HTML><HEAD></HEAD><BODY><P>@gysbert</P><P>Looks like the attachment in your message wasnt successful coz i cant see the attachment. Mind sending it again ?</P></BODY></HTML> Wed, 14 Jan 2015 10:17:25 GMT 2015-01-14T10:17:25Z Need Help with making the expression more granular https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784441#M1035004 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>Greeting of the day.</P><P></P><P>I am working on my first QlikView assignment at the professional level and need help with the below scenario:</P><P></P><P>I am performing Product Analysis ie when you select two products it should show you Companies which have bought both the product "on the same order. ie only products which have the same OrderID". I am using Alternate States for the same.</P><P>Below is the expression that i am using as a Calculated Dimension to show the Companies which have bought both products</P><P>=Aggr(Only({$*[State2]}Customers.CompanyName),Customers.CompanyName)</P><P></P><P>Ill Just explain the expression:</P><P>State2 is the name of the Alternate State I am using for the Second Product</P><P>Customers.CompanyName is the Name of the Company which has bought products.</P><P></P><P>I only need to modify the said expression so that it returns Companies which have bought the two selected Products in the "Same OrderID".</P><P></P><P>I am not sure if you will really need the qvw file for this, but incase you do, or need any more clarifications do ask.</P><P></P><P></P><P>Kind Regards,</P><P>Muntazir Syed</P></BODY></HTML> Wed, 14 Jan 2015 05:53:21 GMT https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784441#M1035004 2015-01-14T05:53:21Z Re: Need Help with making the expression more granular https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784442#M1035005 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 14 Jan 2015 10:13:18 GMT https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784442#M1035005 Gysbert_Wassenaar 2015-01-14T10:13:18Z Re: Need Help with making the expression more granular https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784443#M1035006 <HTML><HEAD></HEAD><BODY><P>@gysbert</P><P>Looks like the attachment in your message wasnt successful coz i cant see the attachment. Mind sending it again ?</P></BODY></HTML> Wed, 14 Jan 2015 10:17:25 GMT https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784443#M1035006 2015-01-14T10:17:25Z Re: Need Help with making the expression more granular https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784444#M1035007 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. Its working the way i want, will study your expressions and add it in my app. </P><P>Thanks for your efforts.</P></BODY></HTML> Wed, 14 Jan 2015 10:26:34 GMT https://community.qlik.com/t5/QlikView/Need-Help-with-making-the-expression-more-granular/m-p/784444#M1035007 2015-01-14T10:26:34Z