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

average of day's over target date.

I'm new to qlikview and want to calculate something between 2 dates and show this on a chart

I have 2 numeric dates for a product:

- Targetdate

- Endate

on the y axus i want the average day's overdue for the product that are over the targetdate. (Exclude the products that are on time)

And on the x axis i will Week, Day or Month. so it need to be calculated for that week, that day and that month.

Thanks

2 Replies
Not applicable
Author

I currently have this:

=if([Targetdate]<[Endate], num([Endate]-[Targetdate]))

But this only works per product.

RedSky001
Partner - Creator III
Partner - Creator III

Can you upload an example .qvw file and the expected output for some of the data, ie product x should be 10 day overdue.  That would make it easier to help you.