I am totally new on Qlik. For my own test I create a very simple sample of datas from 2 sources CSV and Mysql.
For CSV we have 2 files : Order ( id | customer_id | order_sum ) and Customer ( id | name)
For Mysql I have 2 tables : Order ( id | customer_id | order_sum ) and Customer ( id | name)
In Qlik I insert and link then exactly same way = customer_id to id (for Customer). Now I create a chart showing Customer name with order_sum.
On the app with CSV all are correct. In Mysql for order_sum nothing is show... Test and try several times it show nothing.....nada...
Any idea please ???
Solved! Go to Solution.
Ok here some captures :
Here u see CSV source datas and all fine :
See : NAME cross with SELL_SUM.
Here I do EXACTLY same datas from to my DB Mysql :
Here same paramaters but there is no graph appear no matter what I do on it....
And this is why I dont get .....
If both tables having similar columns with same number of count then it will auto concatenate.
To test, give source flag to both tables, it will help you understand which table have given you data in the chart.
Also check format of Customer Id in both sources.
If possible share your script, it will be easier to understand the case
Share either your script or app and someone will have it solved in no time.
I think it is formatting issue on the sell_sum. It looks like the data is connected right and both columns have left aligned data so think it is same type and seems like it has renamed it to a common column name.
Can you check scripting variances in Both apps. In CSV app data connected properly, but in SQL app, think so there's a variance of Customer_id link with Id column in order table.
Might be that's causing the issue of data generation.