Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
ksomosera10
Creator II
Creator II

QlikView Aggregation per Dimension

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.

Capture.PNG

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

 

Labels (1)
1 Solution

Accepted Solutions
edwin
Master
Master

try adding a NODISTINCT inside your aggr function:

...aggr(NODISTICT ...

View solution in original post

3 Replies
edwin
Master
Master

try adding a NODISTINCT inside your aggr function:

...aggr(NODISTICT ...

ksomosera10
Creator II
Creator II
Author

Hi Edwin,

 

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

Thanks a lot!

edwin
Master
Master

np