Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
desmond_mf_fung
Contributor
Contributor

Count the date different if more than 2 months

Hi,

I have 2 tables which connect in Qlik Sense.

the first one table

Entry DateClient numberClient Register Date
14/12/201712345611/12/2017
12/11/20179876549/11/2017
8/3/20174567893/3/2017
5/2/20173216541/2/2017
28/7/201798712326/7/2017
14/5/20171239878/5/2017

the second table

Client numberPurchase Date
12398711/3/2017
65478911/2/2017
32165411/1/2017
12345610/11/2017
98732111/2/2017
9876547/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 Dateno. of count if less than 2 months
Dec-201730
Nov-201715
Oct-201780
Sept-201720
Aug-201733
Jul-201744

Thanks.

2 Replies
sunny_talwar

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

desmond_mf_fung
Contributor
Contributor
Author

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.