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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcushenriquesk

Scatter Plot of time between two date fields per primary key of table

Hello,

I am attempting to make a scatter plot for a dashboard I am creating. Basically, I have a table called REQUISITIONS that contains a primary key (ACC_ID) and two date fields (Received_date, Printed_date). What I want to display in the scatter plot is over a period of received_dates scatter the interval between the received_date and Print_date per accession. For example on received_date = 9/30/2021 I want to see a dot per ACC_ID with the value being the difference between the received_date and Printed_date of that acc_id. I am very amateur and need help with this. thank you!

0 Replies