SQL Error

[#1]

Hello,

I try to implement this query from SAP:

KONV:

SQL Select * from KONV where KNUMV in (Select KNUMV from VBAK WHERE VKORG ='2011' or VKORG ='2012');

store * from KONV into "C:\Documents and Settings\qvadmin\Desktop\Elad\KONV_test\KONV_new.QVD";

DROP TABLE KONV;

And I received this error:

OpenStream failed Key = SQL_ERROR (Number:000) for statemant:

SELECT *FROM KONV WHERE KNUMV IN (SELECT KNUMV FROM VBAK

WHERE VKORG ='2011' OR VKORG ='2012')

KONV:

SQL Select*from KONV where KNUMV in (Select KNUMV from VBAK Where

VKORG ='2011' or VKORG ='2012')

I already implement more queries like that without any problems.

Thank you in advance for your help

Elad

[kozik87]

Hello!

I had the same error here:

LOAD [/BIC/SWKDATSET] AS [Weekly Data Set];

SQL SELECT * FROM /BIC/AGA_O0200 WHERE [/BIC/SWKDATSET] > $(vStartDateKey);

And I removed "[", "]" from the WHERE STATEMENT. And It worked!!

LOAD [/BIC/SWKDATSET] AS [Weekly Data Set];

SQL SELECT * FROM /BIC/AGA_O0200 WHERE /BIC/SWKDATSET > $(vStartDateKey);

I hope that I helped.

Best regards

[#3]

This one came up when searching the forum:

http://community.qlik.com/forums/t/19991.aspx

Could it be the same?

/Michael

[suniljain]

Dear Elad,

Are you get any solution ?. pls share if you get solution.

[suniljain]

Today, I get response from Qliktech on the same.

You can't perform Select......In query on cluster table.

[#6]

Hi Sunil,

Can anyone help me to achive this result:

I want to send 1 report using macro("SEND TO EXCEL") at fixed time suppose 10.00 every morning to a designated folder with the same name everyday.

Suppose i want to save that excel with the "Sample".xls name everyday at 10 .00 in the morning without any user 's manual involvement .

User should see that file in the morning with the "SAMPLE".XLS at fixed time everyday.

Can anyone help me to achieve this using macro.

Regards,

QV Rocks

[suniljain]

in  qlikview sap connector 5.6 . this task become easy.

thanx to qliktech