I'm fairly new to Qlik Sense and I'm trying to do something fairly complicated and would really appreciate some advice. Currently we have a revenue report in Excel that we want to move to Qlik Sense. The calculations in Excel are as follows:
Step 1 is to distribute the segmented amount (-131) across the other three segments based on percentage of current amounts in each Segment:
Step 2 is to distribute the revised "Unallocated Location" amounts across the other four locations based on percentage of current amounts in each Location:
Final table will have no "Unsegmented" amounts and no "Unallocated" amounts.
I don't know whether it's better to perform the calculations in the load script or via set analysis in a pivot table. Any advise and steps would be appreciated.