Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
brunobertels
Master
Master

count NUM_PERSON per DATE_ACTION if NUM_PERSON is already exist in the last 7 days

Hi all 

i need to count per DATE , the number of Client who has already call in the last 7 days 

I put here a sample with only 2 dates but the calculation should works for a 7 days period per date 

 

CLIENT04/01/202105/01/2021
310207813
3706430 4
353239613
330720013
23898812
405407 3
306068 3
3035183 
230331 1
2749133 
8176003 

 

Her you can see that i have for the 05/01/2021 8 Callers but 4 of them has already call the 04/01/2021 

So my distinct count of caller is  8 , but how to get those who called the 05 /01 and in the last 7 days ? 

 

Thank a lot for your help 

i tried with set analysis , P function but without success

 

Regards 

0 Replies