Join two table with DAX Query

shamiul_islam — Sat, 16 Nov 2024 19:22:38 GMT

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 🙂

Re: Join two table with DAX Query

sk88024 — Mon, 30 Dec 2019 13:57:00 GMT

What error are you getting?

Re: Join two table with DAX Query

Brett_Bleess — Mon, 30 Dec 2019 14:45:42 GMT

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

OLAP with MDX

Regards,
Brett

topic Re: Join two table with DAX Query in QlikView

Join two table with DAX Query

Re: Join two table with DAX Query

Re: Join two table with DAX Query