Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

krishnaroopa
New Contributor

Data loading from SQL - rows differ

Hi all

I have a query in SQL, that has group  by Clause, like "Select Dept, count(Studentid) from tbl_Students group by Dept" 

Now i get result like "CSE 5" in SQL Server. 

When i load the data in Qlikview server, I get 5 duplicate rows "CSE 5" 

So strange !!

I tried to put the output to a temp table and select only from that, still duplicate rows!!

Has anyone come across such issue?

Thanks

KRS

 

1 Reply
Highlighted
krishnaroopa
New Contributor

Re: Data loading from SQL - rows differ

Please ignore this question. Found the Issue. In the load, using subField, splitting a column so the rows are duplicated