Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Sum in dimension

Hi all,

I have a list of vessels with the volumes. However, the field that I have selected on my pivot table are fields that are not interlink with the main table. I would want the table to show the list of vessels sorting by the highest volume.

I was thinking whether does the calculated dimension allows aggr function.

i.e if(sum(aggr(sum(TEU)),Vessel_Name, Actual_Time_Berth), Discharge_Vessel_Name)

is there any other solutions

2 Replies
SunilChauhan
Champion
Champion

try this

if(aggr(sum(TEU),Vessel_Name, Actual_Time_Berth), Discharge_Vessel_Name)

Sunil Chauhan
jyothish8807
Master II
Master II

Hi Benn,

If your table is a lose table then I will suggest to try to modify your data model and get a proper data model where all tables have proper link between each other.

For sorting the value you can use firstsortedvalue function.

firstsortedvalue(Vessel_Name,-Volume)

Hope it may help.

Regards

KC

Best Regards,
KC