Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Synthetic Key Help

Hi Qlik Gurus,

I am loading two tables to qlikview, that have common fields. However, they don't seem to be joining correctly.

For example Client in table Retain and Contracting Firm Client Name in GFS is a common field (the spelling is the same), but does not appear so. Therefore, calculations and graphs are skewed and do not show correct results. Please advise to correct this issue.

synkey.PNG

10 Replies
Not applicable
Author

ok so if i make a pivot, then it should show correct results. Is it possible to sort on calculated field in the pivot?