topic SQL Error in QlikView

SQL Error

Thu, 08 Apr 2010 08:49:42 GMT

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

SQL Error

kozik87 — Wed, 17 Nov 2010 13:18:06 GMT

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

SV:SQL Error

Wed, 17 Nov 2010 14:08:13 GMT

This one came up when searching the forum:

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

Could it be the same?

/Michael

SQL Error

suniljain — Sat, 30 Apr 2011 18:08:57 GMT

Dear Elad,

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

SQL Error

suniljain — Mon, 02 May 2011 07:44:33 GMT

Today, I get response from Qliktech on the same.

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

SQL Error

Mon, 02 May 2011 08:14:24 GMT

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

SQL Error

suniljain — Fri, 07 Oct 2011 11:08:37 GMT

in qlikview sap connector 5.6 . this task become easy.

thanx to qliktech