Need help: Numbers are not correctly showing

[#1]

Hi, I am doing an analysis on Qlik Sense and trying to get the headcount month on month. Post uploading the one headcount sheet, plot a bar graph to see the month on month headcount. Numbers were reflecting fine. But when I have uploaded few more sheet like separation , salary etc. numbers are not showing correctly. It is happening only when synthetic keys generated.

Is there some precaution required when columns are identical in different sheets. Please suggest.......... This is spoiling all my efforts........

[MK_QSL]

Provide sample data or sample app along with the expected output.

[sujith1011]

Please rename the identical column and make it unique.

only leave the column identical if you want to make an association between the sheets ,

if multiple columns are required to make an association then concatenate them and make a key

[Colin-Albert]

Qlikview sense does not have separate data for each sheet.

There is a single data model that is common to all sheets.

[TKendrick20]

And remember to use COUNT(DISTINCT [employee]) if your columns contain values you don't intend to count more than once.

[#6]

Thanks everyone for your guidance.. This has helped a lot