topic Re: Sql command issue in qlikview in QlikView

Sql command issue in qlikview

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the below script.When I reload I am getting the error as shown in the image.Please help me to do

ODBC CONNECT TO [PDRMSBKUP;DBQ=PDRMSBKUP ] (XUserId is KMAKLZVNTTcKGYdNSDdcC, XPassword is bDaIOZVNTTcKGYdNSDdKL);

TTTT:

LOAD *;

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= $(vPDRMSBKUP_LWMAIN_RecentDate) ;

Thanks !

Re: Sql command issue in qlikview

Anonymous — Wed, 17 Aug 2016 09:51:21 GMT

try enclose right Expression by '

FROM LEADS.LWMAIN WHERE MODTIME >= '$(vPDRMSBKUP_LWMAIN_RecentDate)';

Re: Sql command issue in qlikview

bhavvibudagam — Wed, 17 Aug 2016 09:58:01 GMT

Tried but getting error as not a valid month.HELP ME TO RESOLVE.

Re: Sql command issue in qlikview

susovan — Wed, 17 Aug 2016 09:59:29 GMT

Hi,

You can also try the attached example process.

Table1:

LOAD Product,

Amount

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1) Where Product='BIKE';

Re: Sql command issue in qlikview

jpenuliar — Wed, 17 Aug 2016 10:08:16 GMT

Is MODTIME date type field? you probably need to use of Date formatting functions to match the expected parameter.

Try TO_DATE()

Re: Sql command issue in qlikview

bhavvibudagam — Wed, 17 Aug 2016 10:12:36 GMT

I am looking for giving Where condition in SQL Table.

Re: Sql command issue in qlikview

adamdavi3s — Wed, 17 Aug 2016 10:15:20 GMT

You need to check the oracle session date format, google is your friend here:

http://stackoverflow.com/questions/12603975/oracle-not-a-valid-month

Please remeber to mark this answer has helpful or correct if it has been helpful or answers your question

Re: Sql command issue in qlikview

bhavvibudagam — Wed, 17 Aug 2016 10:37:46 GMT

Hi,

I have attached the MODTIME Filed. below is my script.Can you please help me how to use TODATE() In my script.

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= $(vPDRMSBKUP_LWMAIN_RecentDate) ;

Thanks,

Re: Sql command issue in qlikview

jpenuliar — Wed, 17 Aug 2016 10:53:01 GMT

Hi Bhavi,

try below:

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= TO_DATE('$(vPDRMSBKUP_LWMAIN_RecentDate))', 'DD/MM/YYYY HH:MI:SS');

Re: Sql command issue in qlikview

bhavvibudagam — Wed, 17 Aug 2016 13:33:59 GMT

Thanks for you help,

but its not working can you please help me how to convert 10/16/2002 2:44:08 PM to number series (4328.5984) in Sql.

Re: Sql command issue in qlikview

adamdavi3s — Wed, 17 Aug 2016 13:39:15 GMT

just convert it to decimal.

In tSQL this is select convert(decimal(12,4),getdate()) but I suspect that oracle is different

Re: Sql command issue in qlikview

bhavvibudagam — Wed, 17 Aug 2016 14:15:42 GMT

ODBC CONNECT TO [PDRMSBKUP;DBQ=PDRMSBKUP ] (XUserId is KMAKLZVNTTcKGYdNSDdcC, XPassword is bDaIOZVNTTcKGYdNSDdKL);

This is the connection which we have used can you please tell me in oracle also

Re: Sql command issue in qlikview

adamdavi3s — Wed, 17 Aug 2016 14:18:59 GMT

You probably don't want to go sharing your connection string on the web

It is of no use to us anyway

Can I suggest that you google the issue as it would appear to be an ORACLE issue rather than a qlik one, please see my message below for a pointer in the right direction!

Re: Sql command issue in qlikview

kaushiknsolanki — Wed, 17 Aug 2016 14:43:04 GMT

Hi,

Try this,

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= TO_DATE('$(vPDRMSBKUP_LWMAIN_RecentDate)', 'DD/MM/YYYY hh:mm:ss TT');

Regards,

Kaushik Solanki