Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help: Numbers are not correctly showing

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........

5 Replies

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

Partner - Creator
Partner - Creator

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


Qlikview sense does not have separate data for each sheet.

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

Partner - Specialist
Partner - Specialist

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

Not applicable

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