QlikView Aggregation per Dimension

[ksomosera10]

Hi,

I'm working on QlikView and I encounter some challenges that I cannot resolve.

I'm trying to get the percentage in terms of delay and on-time using a pivot table.

However, It always  shows on-time and not showing on both delay and on-time.

I've tried many expressions including AGGR but I don't achieve what I want.

Basically what I want to achieve on the % column is by dividing the number of shipment (either delay and/or on-time) to the total shipments.

I've used count(total(totalshipment)) on the 3rd column, it works only when I filtered 1 shipment date.

I'll change when I remove any filter.

I want to get only, per dimension the total shipment for both delayed and on-time.

Can you help me with this?

That'll be great.

Thank you in advance!

-Kevin

[edwin · Accepted solution]

try adding a NODISTINCT inside your aggr function:

...aggr(NODISTICT ...

[ksomosera10]

Hi Edwin,

Thanks! It works!!! I'm not quite familiar with AGGR so this is really new to me.

Thanks a lot!

[edwin]

np