I link 2 sources using a key
Source 1: currency&playercode&date as Key, indicator,amount etc..
Source 2:currency&playercode&date as Key, settledamount, status etc..
The above both are linked using key.. when i bring it on the table. Iam getting hyphens somehow.. it does not exist in the source files.. because of these hyphens the amount gets reduces in totals .The data model is quite simple .only key is linked no other issues.
and the main part is that on the qliksense table iam not able to filter the hyphens , i can see the hyphens only after downloading into excel..
I would want these - to be 'Y' . i tried doing in the table if indicator is null or '-' then 'Y' but it does not change anything..
| Key | indicator | amount | status |
| GBPKLM4325 | - | 1,300,024 | OK |
| GBPKLM4326 | - | 197,634 | No |
| GBPKLM4327 | - | 87,600 | OK |
| GBPKLM4328 | - | 76,433 | OK |
| GBPKLM4329 | Y | 126,546 | OK |
| GBPKLM4330 | Y | 765,432 | OK |
| GBPKLM4331 | Y | 887,642 | OK |
| GBPKLM4332 | Y | 234,567 | OK |
| GBPKLM4333 | Y | 775,237 | No |
| GBPKLM4334 | Y | 1,356,789 | No |
| GBPKLM4335 | Y | 187,643 | No |
| GBPKLM4336 | Y | 887,634 | No |
| GBPKLM4337 | Y | 207,896 | No |
