Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am a retailer EC site marketer, and I am trying Qlik Sense.
First, I am Japanese. I am sorry if my English is wrong.
I want to calculate the number of purchases during the term.
Example data,
No | Date | Name
1 | 2016/01/01 | a
2 | 2016/03/10 | b
3 | 2016/07/12 | b
4 | 2016/09/19 | a
5 | 2016/11/21 | c
6 | 2017/01/11 | a
7 | 2017/08/10 | c
8 | 2017/12/30 | d
9 | 2018/02/02 | b
10 | 2018/06/20 | a
I want to this,
No | Date | Name | purchases on a year
1 | 2016/01/01 | a | 1
2 | 2016/03/10 | b | 1
3 | 2016/07/12 | b | 2
4 | 2016/09/19 | a | 2
5 | 2016/11/21 | c | 1
6 | 2017/01/11 | a | 2
7 | 2017/08/10 | c | 2
8 | 2017/12/30 | d | 1
9 | 2018/02/02 | b | 1
10 | 2018/06/20 | a | 1
Can I help me, how to calculate "purchases on a year"?
i have created a nice little app that you can play with:
(see attachment)
best wishes.
alternatively, if you wish to do it in the script:
Thank you for your reply, and I'm sorry to late reply.
I tried to your app, but its not what I want.
I would like to calculate "purchases on a year" on the table.
Because I want to do more detailed calculations using it.
It is not possible?