Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Masha2280
Contributor
Contributor
‎2019-02-21 05:32 AM

Wrong sales value for last year after concatenate the table with current year table

Hi,

I have several csv. files for different years. When I associate the sale.order 2018 and sale.orderlines 2018 the sales is 16102 units

but when I add the sale.order 2019 and sale.ordelines 2019 as well, which qlik automatically concatenates them because they have the same fields names, the value for 2018's sale will increase to 17678 units. I have read that concatination in qlik will only join the tables together, but in my case, most probably during concatination some extra rows of data is created. Do you have any suggestion, how can I get the accurate sale number?

Associations.jpg

191 Views
0 Likes
0 Replies