Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Getting value for a dynamic date range using Set Analysis

Hi,

I am new to Set Analysis, appreciate your inputs on the following scenario. I have a table as follows:

Service Number
Service DateCustomer ID
100019/1/20141
100029/2/20141
100039/12/20141
100049/2/20142
100059/5/20142
100069/3/20143
100079/12/20143
100089/4/20144
100099/5/20144
100109/6/20145
100119/21/20145

Problem: I need to find the distinct number of customers who availed a service for the first time for a date range (say in this case from 9/1/2014 to 9/5/2014) and then came back within 5 days of availing the service. In the above example the count should consider only the customers 1, 2 and 4.

Thank you!

Tags (2)
1 Solution

Accepted Solutions

Re: Re: Getting value for a dynamic date range using Set Analysis

Hi

PFA

hope it helps

6 Replies
Not applicable

Re: Getting value for a dynamic date range using Set Analysis

Hi

Find out the below app attached and let us know the approach sutis the requirement

Not applicable

Re: Getting value for a dynamic date range using Set Analysis

small corerction

istead of using "sum" in the expression use "count "

you would get desired result

Not applicable

Re: Getting value for a dynamic date range using Set Analysis

Hi,

Thanks for your inputs, unfortunately it is not solving the problem i described. This is giving all the customers count for the date range 9/1/2014 to 9/5/2014. I want the count of only those customers who came back within 5 days of availing the first service. In the example i have given the count should consider only the customers 1,2 and 4 as they have come back within 5 days of availing the first service.

Not applicable

Re: Getting value for a dynamic date range using Set Analysis

try for subroutine

if you are not aware of it try to find it out in the community,it may help you

Re: Re: Getting value for a dynamic date range using Set Analysis

Hi

PFA

hope it helps

Not applicable

Re: Getting value for a dynamic date range using Set Analysis

Thanks Mayil!!!!! This solved my problem.

However I am still curious to know if this can be done through set analysis and not add anything to the scripts.

Thank You!!!!

Community Browser