association is not working when load a typical excel file

[Anonymous]

In this QVW Organizational data and Remedy group ,consolidated group is not associate with each other ,if i click Applications from

Organizational it is showing single data only but in excel there are number of groups associated to Applications

just check it QVW file and Excel file so that you can understand..

please help me out..

[jonathandienst]

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.

[Gysbert_Wassenaar]

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.