Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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.