Qlik Community

New to Qlik Sense

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
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
MK_QSL
MVP
MVP

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

sujith1011
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

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

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