Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would you be able to explain how you got the output that you have shown above? May be in an Excel file?
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.