Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This is not a solution, but i can take the data, creating a view on the mssql and calling in my qlikview
Regards
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?
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