topic Re: association is not working when load a typical excel file in QlikView https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836285#M294156 <HTML><HEAD></HEAD><BODY><P>You need to do a little more analysis of your data. There are no values of Group Priority Key that exist in both the Categories table and the Remedy_HD table, so there is effectively no association between the rows in those tables.</P></BODY></HTML> Tue, 12 May 2015 05:37:17 GMT jonathandienst 2015-05-12T05:37:17Z association is not working when load a typical excel file https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836284#M294155 <HTML><HEAD></HEAD><BODY><P>In this QVW Organizational data and Remedy group ,consolidated group is not associate with each other ,if i click Applications from</P><P>Organizational it is showing single data only but in excel there are number of groups associated to Applications </P><P></P><P>just check it QVW file and Excel file so that you can understand..</P><P></P><P>please help me out..</P></BODY></HTML> Tue, 12 May 2015 02:31:37 GMT https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836284#M294155 Anonymous 2015-05-12T02:31:37Z Re: association is not working when load a typical excel file https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836285#M294156 <HTML><HEAD></HEAD><BODY><P>You need to do a little more analysis of your data. There are no values of Group Priority Key that exist in both the Categories table and the Remedy_HD table, so there is effectively no association between the rows in those tables.</P></BODY></HTML> Tue, 12 May 2015 05:37:17 GMT https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836285#M294156 jonathandienst 2015-05-12T05:37:17Z Re: association is not working when load a typical excel file https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836286#M294157 <HTML><HEAD></HEAD><BODY><P>You have merged cells in your excel file. This results in lots of nulls when you load that data into Qlikview if you don't use a transformation step to fill in the blanks. You can see that in the Table Viewer.</P></BODY></HTML> Tue, 12 May 2015 08:01:13 GMT https://community.qlik.com/t5/QlikView/association-is-not-working-when-load-a-typical-excel-file/m-p/836286#M294157 Gysbert_Wassenaar 2015-05-12T08:01:13Z