An error while implementing inner join to qlikview script

[Anonymous]

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?

[Anil_Babu_Samineni]

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

[effinty2112]

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

[ahmar811]

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