Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AdrianS1
Contributor III
Contributor III

Orders packed per day

Hello guys, I have a table like this:

AdrianS1_0-1709298211068.png

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?

 

Labels (3)
2 Replies
theoat
Partner - Specialist
Partner - Specialist

Can you reach the QVF?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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