topic Aggregate from several values in QlikView https://community.qlik.com/t5/QlikView/Aggregate-from-several-values/m-p/738266#M263942 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I will ask you a question about an aggregate of suppliers.</P><P></P><P>You can see in the excel file join to this message that I have several supplier names for several sites.</P><P>Sites A, B, C are loaded from databases, but Supplier Aggregate is loaded from an Excel file and represent the name of one supplier.</P><P></P><P>If we select EATON, we must have EATON A, B and C selected.</P><P></P><P>Do you know how do I get to do that?</P><P>For the moment, I named Suppliers field from Excel and Database as [Supplier Name], but with this I lost the aggregate name "EATON" and have only EATON A, B and C.</P><P></P><P>Thanks for your help ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Oct 2014 09:45:19 GMT 2014-10-16T09:45:19Z Aggregate from several values https://community.qlik.com/t5/QlikView/Aggregate-from-several-values/m-p/738266#M263942 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I will ask you a question about an aggregate of suppliers.</P><P></P><P>You can see in the excel file join to this message that I have several supplier names for several sites.</P><P>Sites A, B, C are loaded from databases, but Supplier Aggregate is loaded from an Excel file and represent the name of one supplier.</P><P></P><P>If we select EATON, we must have EATON A, B and C selected.</P><P></P><P>Do you know how do I get to do that?</P><P>For the moment, I named Suppliers field from Excel and Database as [Supplier Name], but with this I lost the aggregate name "EATON" and have only EATON A, B and C.</P><P></P><P>Thanks for your help ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Oct 2014 09:45:19 GMT https://community.qlik.com/t5/QlikView/Aggregate-from-several-values/m-p/738266#M263942 2014-10-16T09:45:19Z Re: Aggregate from several values https://community.qlik.com/t5/QlikView/Aggregate-from-several-values/m-p/738267#M263943 <HTML><HEAD></HEAD><BODY><P>Allow me to ascend the topic, if someone can help me ?</P><P>Thanks !</P></BODY></HTML> Tue, 21 Oct 2014 13:49:20 GMT https://community.qlik.com/t5/QlikView/Aggregate-from-several-values/m-p/738267#M263943 2014-10-21T13:49:20Z