topic Re: An error while implementing inner join to qlikview script in QlikView

An error while implementing inner join to qlikview script

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

Hi all

When I am implementing joins to a database I am getting an error as 'error converting data type varchar to numeric' What may the reason behind the same?

Re: An error while implementing inner join to qlikview script

Anil_Babu_Samineni — Wed, 02 Aug 2017 07:12:07 GMT

Looks like Join condition should work within SQL queries thru Qlikview. But,, I am not sure what are you doing here. Will you able to explain little more related the Data

Re: An error while implementing inner join to qlikview script

effinty2112 — Wed, 02 Aug 2017 07:33:29 GMT

Hi Saksham,

How is the variable currentdate defined?

If it is to be today's date then you need something like this earlier in the script;

Let currentdate = Date(Today(),'YYYYMMDD');

cheers

Andrew

Re: An error while implementing inner join to qlikview script

ahmar811 — Wed, 02 Aug 2017 07:42:38 GMT

Hi,

Kaul

I think your currentdate variable not declared properly in above script it's show as null(nothing)

use below expression in your script:

Let currentdate = Date(Today(),'YYYYMMDD'); //Date format should same as SD.SalesDate format

Regards

Ahmar