Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
New Contributor II

Join two table with DAX Query

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 🙂

2 Replies
Highlighted
New Contributor

Re: Join two table with DAX Query

What error are you getting?

Highlighted
Digital Support
Digital Support

Re: Join two table with DAX Query

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

OLAP with MDX 

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.