Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

select and group by

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

12 Replies
swuehl
MVP
MVP

Hi Cesar,

have you tried to use <> or not  instead of != as comparison operator?

Regards,

Stefan

Not applicable
Author

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

rajeshvaswani77
Specialist III
Specialist III

Hi Cesar,

       You have put co1 as cod1 in group by.

Thanks,

Rajesh Vaswani

rajeshvaswani77
Specialist III
Specialist III

Hi Cesar,

       You have put co1 as cod1 in group by.

Thanks,

Rajesh Vaswani

Not applicable
Author

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!!

rajeshvaswani77
Specialist III
Specialist III

semicolon at the end?

Not applicable
Author

Hi:

the simicolon, exist in my scrip in qlickview, and the error is the same

Thanks!

rajeshvaswani77
Specialist III
Specialist III

Hi,

   Can you post the script?

Thanks,

Rajesh Vaswani

Not applicable
Author

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