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
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);
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.