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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Make an avg on 2 dates with a distinct variable

Hi

I'm new to qlikview and have a problem with a chart. I want to show the average time between 2 dates and use this expression:

round(Avg((end_date+end_time)-(start_date+start_time)),0.01)

It works fine, but my problem is that I want to add: distinct(case_id)

who to do that?

0 Replies