Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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