Qlik sense cannot find associations between Excel file and DWH table
Today I have created my first app in Qlik Sense and I got stuck from the beginning. Part of my data comes from a table in DWH and another part let say segmentation for each customer comes from excel file. I have uploaded both in app but Qlik cannot find associations between the client ID columns. I have typed associations manually but when I come to analysis tab and start to add charts and filters, filters work only if dimensions and measures are from the same table. I thought maybe client ID, which is depicted as a number is in text format in DWH table and numeric in excel and tried to add calculated field changing the format. It didn't work.
I have renamed the column name in excel to match DWH table and the ID column in DWH automatically added name of the table to the column name. I don't think it is name problem. When I look on both tables in associations I can see that numbers in one table are aligned to the left and in another to right. Maybe there is a way to adjust format of ID for excel in script editor?