topic Min max date based on product usage. in QlikView

Min max date based on product usage.

Mon, 14 Apr 2014 02:37:42 GMT

Hello there folks,

First and foremost, couldn't think of a suitable title for the discussion - am going to try my best to explain the situation in detailed.

Planning on developing a report for a subscription based service. Trying to find out a way to compute/script - usage of the service by customers based on the (no. of days). The script would look something like this:-

Based on (customer) {

Max(usage date) - Min(usage date) = no. of days using the service

}

Please advise. Thanks.

Best Regards,

Re: Min max date based on product usage.

Mon, 14 Apr 2014 03:12:15 GMT

Hi Ram,

Here's one option for calculating retention in your script. If this doesn't work, try attaching a sample or explain your data structure in more detail.

Let me know if you have any questions.

Best,

Matt

Re: Min max date based on product usage.

Mon, 14 Apr 2014 03:35:13 GMT

Hi Matt,

Thanks for the quick reply. Will test it out and let ya know. Cheers.

Best Regards,