Join two table with DAX Query

[shamiul_islam]

I want to join two tables with DAX query in Qlikview. I wrote a query to join the tables. But that gave me a script error. The query is given below

JOIN:

LOAD
'NOVONORDISK' as OCOMPANY
,"Sales Summery[AUDTORG]" as SS_Branch
,"Sales Summery[INVNUMBER]" as Out_INVNUMBER
,"Sales Summery[CUSTNAME]" as SS_NAME
,"Sales Summery[CUSTOMER]" as SS_ID
,"Sales Summery[CUSTYPEDESC]" as SS_TYPE
,"Sales Summery[MARKETNAME]" as SS_MARKET
,"Sales Summery[INVNETH]" as INVNET
,"ArreceiptAdjustment[DOCNET]" as DOCNET
,"Sales Summery[TERMS]" as OTERMS
,DATE(DATE#("Sales Summery[INVDATE]",'YYYYMMDD'), 'DD-MM-YYYY') AS OTRDate
,'NOVONORDISK'&'-'&rTrim("Sales Summery[CUSTOMER]")&'-'&rTrim("Sales Summery[AUDTORG]") AS LCust;

OLEDB CONNECT TO [Provider=MSOLAP.4;Persist Security Info=True;User ID=yakub;Initial Catalog=NOVO_ALLL;Data Source=10.168.2.160;Location=TDCLSSASSVR] (XPassword is VVJSRSJOQbOA);

SQL EVALUATE NATURALLEFTOUTERJOIN('Sales Summery','ArreceiptAdjustment');

STORE JOIN INTO QVD_SSAS_NOVO_OUTJOIN.qvd;

I can't find any wrong syntax here. Can anyone help me that What is wrong with this script.

Thanks in advance 🙂

[sk88024]

What error are you getting?

[Brett_Bleess]

Check out the following Support Article, it may be of some help, but cannot say for certain:

OLAP with MDX 

Regards,
Brett