Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Please ignore this question. Found the Issue. In the load, using subField, splitting a column so the rows are duplicated