topic Re: Sum in dimension in QlikView

Sum in dimension

n1ef5ng1 — Wed, 03 Dec 2014 02:58:56 GMT

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

Re: Sum in dimension

SunilChauhan — Wed, 03 Dec 2014 03:06:20 GMT

try this

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

Re: Sum in dimension

jyothish8807 — Wed, 03 Dec 2014 03:23:07 GMT

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