topic Re: QlikView Aggregation per Dimension in QlikView

QlikView Aggregation per Dimension

ksomosera10 — Fri, 15 Nov 2024 23:20:31 GMT

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 — Tue, 12 Jan 2021 21:30:27 GMT

try adding a NODISTINCT inside your aggr function:

...aggr(NODISTICT ...

ksomosera10 — Wed, 13 Jan 2021 06:26:00 GMT

Hi Edwin,

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

Thanks a lot!

edwin — Wed, 13 Jan 2021 14:24:56 GMT