Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.