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
Hi Cesar,
have you tried to use <> or not instead of != as comparison operator?
Regards,
Stefan
Hi Stefan:
I Change != for <> and the error is the same
OLEDB read failed
without the group by, the sentece work fine
Thanks, regards
César Estrada
Hi Cesar,
You have put co1 as cod1 in group by.
Thanks,
Rajesh Vaswani
Hi Cesar,
You have put co1 as cod1 in group by.
Thanks,
Rajesh Vaswani
Hi Rajesh:
Is true, but is not the error.
OLEDB
[Provider=SQLNCLI10.1;Integrated Security=SSPI;Persis ......
SQL
select
account,date1,date2,cod1,cod2,sum(price)
from table
where account != '7777777701'
group by account, date1, date2, cod1, cod2
Thanks!!
semicolon at the end?
Hi:
the simicolon, exist in my scrip in qlickview, and the error is the same
Thanks!
Hi,
Can you post the script?
Thanks,
Rajesh Vaswani
Hi
The script is
OLEDB
[Provider=SQLNCLI10.1;Integrated Security=SSPI;Persis ......
SQL
select
account,date1,date2,cod1,cod2,sum(price)
from table
where account != '7777777701'
group by account, date1, date2, cod1, cod2 ;
Thanks