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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help! How to design charts with date calculations

Hey guys. Need a little help here.

I have 2 tables, with a field in each table as such:

1 table has a "date received" field

1 table has a "date sent" field

basically, I need a chart that filters by month (Jan through Dec), then shows how many letters were sent out in a timely fashion. when a letter is received (date received), it has to go out (date sent) within 60 days. if it's sent within that time frame, it's in a "timely fashion".

I have no clue how to do this. From what I can tell, first I have to do a "date received - date sent" calculation, then a calculation that says if that <= 60, then count that as "good". The chart then should show this, broken down by month, as a percentage (100%, 99%).

Should this be done in 2 steps? Maybe create a table with "date received - date sent", then do a count of that?

Help!!! 

5 Replies
Not applicable
Author

Try using below expression .

count(if((DateSent-DateReceived)<=60,DateSent))

Not applicable
Author

Awesome! Where would I use that expression, if I wanted to supply this data in a chart? (Sorry - I'm still quite a novice.)

sujeetsingh
Master III
Master III

Just go for a expression and add it in a chart or Table you want

Not applicable
Author

thanks everyone. you bunch of smarties.

Not applicable
Author

thanks everyone. you bunch of smarties.