Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys, I have a table like this:
How I can get a % of packed order day per day. Here I have 8 orders to packed, and 7 with status completed witch means that the status of packed order is completed. But in table we see 10 packed orders because three of them is packed today but the received day was two days before. I want to show day per day, % of packed parcels on single day, how I can do this?
Can you reach the QVF?
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
You will need to set up a canonical date / bridge table that contains both order date and packed date. Download this Qlik Sense example
https://qlikviewcookbook.com/list-recipes/#squelch-taas-accordion-shortcode-content-19
which demonstrates showing both orders received and orders shipped for a geven period.
-Rob