Discussion board where members can learn more about Qlik Sense App Development and Usage.
Trying to join these two tables.
Now I'm trying to add table 2 field to the main Fact table Customer_FX:
left join (Customer_FX)
group by FX_Key;
Getting this error message:
Aggregation expressions required by GROUP BY clause
The error occurred here:
left join (Customer_FX) Load ThisFXRate Resident MergeAll_FX group by FX_Key
When using group you need to use aggregation function like
SUM(ThisFXRate) as TotalFX
Thank you Robert, i need the field in its original state. Sum will change the value. Any ideas?
The record count in the Fact table went from 50K to 19M also. Not what I expected. (some merge ha? )
What are you trying to achieve?
Maybe like this?
Then the Customer table will be joined on your FX_Key
no need for group statement.
Then you can drop the MergeAll_FX table
As an alternative use AppplyMap
Don't join - use Applymap instead
How To /Missing Manual(25 articles)