This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!
try adding a NODISTINCT inside your aggr function:...aggr(NODISTICT ...
View solution in original post
Thanks! It works!!! I'm not quite familiar with AGGR so this is really new to me.
Thanks a lot!