Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Finding average days between two dates

Greetings Community,

I have a set analysis to find the average days that students are on the waitlist for a course.

Course being my Dimension, and "Average Days on Waitlist" being my Measure.

My code for the Measure looks like this:

avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date)))

I am having trouble building the code to show only the course(s) that have less then or equal 100 days.

Thoughts?

1 Solution

Accepted Solutions
Highlighted

Re: Finding average days between two dates

May be this:

Date(Avg({$<transcript_status_code = {'W','w'}, Course = {"=Today() - waitlist_date <= 100"}>}(Today() - waitlist_date)))

or

If(Today() - waitlist_date <= 100, Date(Avg({$<transcript_status_code = {'W','w'}>} (Today() - waitlist_date))))

View solution in original post

5 Replies
Highlighted
Contributor II
Contributor II

Re: Finding average days between two dates

Hi Mike

Will this work ...?

=if(Avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date)))>100,0,

Avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date)))

Nav Pienaar

Highlighted
Specialist
Specialist

Re: Finding average days between two dates

May be this

avg({$<transcript_status_code = {'W','w'},Course={"=(date(today(),'MM/DD/YYYY')-waitlist_date)<=100"}>}(date(today() - waitlist_date)))

Highlighted

Re: Finding average days between two dates

May be this:

Date(Avg({$<transcript_status_code = {'W','w'}, Course = {"=Today() - waitlist_date <= 100"}>}(Today() - waitlist_date)))

or

If(Today() - waitlist_date <= 100, Date(Avg({$<transcript_status_code = {'W','w'}>} (Today() - waitlist_date))))

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Finding average days between two dates

Thank you!

I had to use the If statement to get it to work with a little finesse.

I appreciate your help all!

Highlighted
Contributor III
Contributor III

Re: Finding average days between two dates

yes,

That is actually the exact code I implemented.

if(avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date))) <= 100, avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date))), null())