Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading data from SQL 2008 into Qlikview

Hi, I am loading data from my SQL Server 2008 database, but I get duplicate values when I create reports in qlikview. These duplicates are not available on the source data. How do I resolve this.

2 Replies
SunilChauhan
Champion II
Champion II

use distinct while loading

Load distinct ;

select

from table.

check weither you apply any of following correctly

join

concatenate

Sunil Chauhan
Not applicable
Author

It doesn't change a thing