select and group by

[#1]

Hi:

One simple question, why this script work in tsql (mssql) and not in qlikview

OLEDB

[Provider=SQLNCLI10.1;Integrated Security=SSPI;Persis ......

SQL

select

account,date1,date2,co1,cod2,sum(price)

from table

where account != '7777777701'

group by account, date1, date2, cod1, cod2

Any Idea???

Thanks, regards

César Estrada

[#2]

This is not a solution, but i can take the data, creating a view on the mssql and calling in my qlikview

Regards

[ToniKautto]

The SELECT statement in your QlikView script is sent as written from QlikView to the database connector and then interpreted by the database. Generally if a database query does not function the problem would not be QlikView since it is not interpreted in QlikView. Please do the following steps to narrow down here it is going wrong.

1. Please make sure that you are using the same user in your QlikView connect statement as you are in your succesful test

2. Make sure the conenct statement works, by making a SELECT * for an arbitrary table

3. Try exactly the same SELECT statement from an other application like Excel, by using exactly the same connector

If the problem still remains, please specify what the sympthom of your issue is.

Do you get a error message, and what does it say?

Do you get incorrect data, specify expected and retrieved data?

[#4]

you can also do one more thing:

1. first load the table from sql.

2. then apply group by clause by making previously loaded table as resident.

try it.

regards