topic Re: Count the date different if more than 2 months in Connectivity & Data Prep

Count the date different if more than 2 months

desmond_mf_fung — Tue, 17 Apr 2018 09:26:31 GMT

Hi,

I have 2 tables which connect in Qlik Sense.

the first one table

Entry Date	Client number	Client Register Date
14/12/2017	123456	11/12/2017
12/11/2017	987654	9/11/2017
8/3/2017	456789	3/3/2017
5/2/2017	321654	1/2/2017
28/7/2017	987123	26/7/2017
14/5/2017	123987	8/5/2017

the second table

Client number	Purchase Date
123987	11/3/2017
654789	11/2/2017
321654	11/1/2017
123456	10/11/2017
987321	11/2/2017
987654	7/5/2017

Now, I would like to count only if the date different between Client Register Date - Purchase Date less than 2 months. i.e. how many client register the account after 2 months of their purchase. If it's over 2 months, do not need to count.

The outcome should be presented in month, like below. How can I write the expression?

Entry Date	no. of count if less than 2 months
Dec-2017	30
Nov-2017	15
Oct-2017	80
Sept-2017	20
Aug-2017	33
Jul-2017	44

Thanks.

Re: Count the date different if more than 2 months

sunny_talwar — Tue, 17 Apr 2018 11:24:42 GMT

Would you be able to explain how you got the output that you have shown above? May be in an Excel file?

Re: Count the date different if more than 2 months

desmond_mf_fung — Wed, 18 Apr 2018 01:25:10 GMT

the output is just the format that I want, it's not the real number, not in excel or else software.
I had tried

count(interval([purchase date] - [client register date]), <2)

but it's failed.

Please help.