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!