Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkey2847
Contributor II
Contributor II

Datamismatching

Hi all,

I have one table in sql server  with 3000 records.

I have applied filters and group by on that table and I got 2000 records.

Now I am doing same in Qlikview,  it will give 3000 records but when I applying filters and group by it is giving less than 2000 records.

I have aggregation functions are COUNT and SUM.

Could you please help me on this issue.

Thanks

Venkey.

1 Reply
vinieme12
Champion III
Champion III

just by looking at your query we understand the problem but your description does not provide any information on  HOW EXACTLY you are applying the filters in Sql server or Qlikview!

You haven't posted your sql query neither your qlikview load statement; and people can't really help you find a problem they can't see!

How to get answers to your post?

You can use your SQL select statement in conjunction with the load statement as below, so no need to recreate your sql query in qlikview

example

Load *

SQL SELECT field1,field2,field3

FROM  <<>>   WHERE  <<>>;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.