Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Min max date based on product usage.

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,

R

2 Replies
Not applicable

Re: Min max date based on product usage.

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

Not applicable

Re: Min max date based on product usage.

Hi Matt,

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

Best Regards,

R

Community Browser