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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-09-16 02:31 PM

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

1,298 Views
0 Likes
10 Replies
Not applicable
‎2016-09-16 03:34 PM
Author

In response to krishnacbe

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

148 Views
0 Likes