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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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