Solved: Re: count customer who call more than 5 time with... - Qlik Community

manojin123 · ‎2021-07-20

Hi Everyone,

Hope you guys help me on below issue.

I need to create a master measure which show the customer call more than 5 time in 14 days .

Here is the sample data

DtTm, ContactId ,CALLS
7/6/2021 12:55:31 PM ,1, 1
7/8/2021 11:13:17 AM 2 1
7/11/2021 2:13:48 PM 3 1
7/9/2021 1:39:33 PM 1 1
7/7/2021 12:05:02 PM 1 1
7/23/2021 12:56:04 PM 3 1
7/9/2021 3:30:30 PM 5 1
5/10/2021 3:30:30 PM 1 1
4/11/2021 3:30:30 PM 2 1
3/12/2021 3:30:30 PM 5 1
5/13/2021 3:30:30 PM 4 1
6/14/2021 3:30:30 PM 3 1
5/15/2021 3:30:30 PM 2 1
2/16/2021 3:30:30 PM 1 1
6/17/2021 3:30:30 PM 1 1
3/18/2021 3:30:30 PM 3 1

Michael_K · ‎2021-07-22

Hi,

1. Add in the script a flag for every row:
if(Timestamp#(DtTm,'DD/MM/YYYY hh:mm')>=now()-14,1,0) as Is14Flag

2. Use set analysis with the new field:
=sum({<Is14Flag={1}>}CALLS)

View solution in original post

Michael_K · ‎2021-07-22

Hi,

1. Add in the script a flag for every row:
if(Timestamp#(DtTm,'DD/MM/YYYY hh:mm')>=now()-14,1,0) as Is14Flag

2. Use set analysis with the new field:
=sum({<Is14Flag={1}>}CALLS)

manojin123 · ‎2021-07-25

Thank you it worked

count customer who call more than 5 time within 2 weeks