Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I currently have this:
=if([Targetdate]<[Endate], num([Endate]-[Targetdate]))
But this only works per product.
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.