Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

select and group by

Hi Cesar,

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

Regards,

Stefan

Not applicable

select and group by

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
Valued Contributor III

select and group by

Hi Cesar,

       You have put co1 as cod1 in group by.

Thanks,

Rajesh Vaswani

rajeshvaswani77
Valued Contributor III

select and group by

Hi Cesar,

       You have put co1 as cod1 in group by.

Thanks,

Rajesh Vaswani

Not applicable

select and group by

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
Valued Contributor III

select and group by

semicolon at the end?

Not applicable

select and group by

Hi:

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

Thanks!

rajeshvaswani77
Valued Contributor III

select and group by

Hi,

   Can you post the script?

Thanks,

Rajesh Vaswani

Not applicable

select and group by

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