Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
knakamura1
New Contributor

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
Partner
Partner

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

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

(see attachment)

best wishes.

Partner
Partner

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

knakamura1
New Contributor

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

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?