topic Re: Repeat Customer Logic in Qlik View Scripting in QlikView

Repeat Customer Logic in Qlik View Scripting

Nisha_Pra — Sat, 16 Nov 2024 00:11:17 GMT

Hi All,

Repeat Caller Logic within 48 hours . (Repeat caller duration is based on callstartdate and prevcallsegstartdate as per the example provided)

Formula: Numerator - Unique Contact, Denominator - Unique + Repeat Contact

CustomerPhone	CallID	Callstartdate	Callenddate	prevcallstartdate	repeatcalldurationSecs
123	Call1	2020-06-08 11:13:05.000	2020-06-08 11:28:48.000	NULL	NULL
123	Call2	2020-06-08 11:39:35.000	2020-06-08 11:50:23.000	2020-06-08 11:13:05.000	1590
123	Call3	2020-06-11 15:24:07.000	2020-06-11 15:33:56.000	2020-06-08 11:39:35.000	272672
126	Call12	2020-03-22 14:40:49.000	2020-03-22 15:09:42.000	NULL	NULL

From the above example - In the case of 123 phone number (1-2 row number) - its a repeat contact.
This customer contacted twice within 48 hours based on the first two rows

Now in the numerator - it should be 0
in the denominator - it should be 2

3rd row - again the same customer contacted after 48 hours, it should treat as a new customer
Now numerator - 1 and denominator - 1

In case of 126 customer phone number - its unique contact
Now numerator - 1
denominator - 1

Total KPI value - Numerator - 0+1+1
Denominator - 2+1+1

Can someone help me how I can achieve this in Qlik?

Re: Repeat Customer Logic in Qlik View Scripting

Brett_Bleess — Wed, 19 Aug 2020 15:00:01 GMT

I believe you are going to need to provide some further clarification of the use case and I would segregate your actual input data and your expected/desired output, so it is clear to folks what exactly you are trying to accomplish, believe that is likely why you have not received any responses, as it is a bit unclear to me exactly how you are trying to go about things given some of the commentary does not really seem to tie into the data you provided.

Regards,
Brett

Re: Repeat Customer Logic in Qlik View Scripting

Brett_Bleess — Wed, 19 Aug 2020 15:50:58 GMT

See duplicate post: https://community.qlik.com/t5/New-to-QlikView/Identifying-Repeat-and-Unique-Customers/m-p/1733790#M391871

Regards,
Brett