Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

1 Sheet Doubling Count of 1 Field

I have 5 sheets(.xslx) that I have pulled into Qlik Sense Desktop. All of them share at least 2 field names, some up to 4 or 5. (It also won't allow me to associate them all even though they are the same data.)  For some reason, one of the sheets is doubling the amount in a certain column (Total Spent to be exact).  I have tried to remove the sheet and start over and for some reason it only keeps happening to this one sheet I'm pulling in.

Any suggestions or thoughts?  It's driving me nuts that I can't figure it out.

Thanks!

2 Replies
brunobertels
Master
Master

Hi

can you share your .xlsx file or/and your app

Not applicable
Author

Hi,

Here is a screenshot of the app with the lnkd spent being way higher than what is totaled in the LinkedIn spreadsheet attached.

Marketing_ROI_QlikSense.png