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: 
Anonymous
Not applicable

How can I calculate the number of purchases during the term?

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"?

3 Replies
wade12
Partner - Creator II
Partner - Creator II

i have created a nice little app that you can play with:

(see attachment)

best wishes.

wade12
Partner - Creator II
Partner - Creator II

Anonymous
Not applicable
Author

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?