Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Daily transactions made by individuals in consecutive months

Hi Everyone

I have a table that consists of daily transactions made by individuals(UID). An individual can have multiple transactions on a daily basis.

I need to find out for in the last 6 months which of these individuals made a transaction for 3 consecutive months adding up to a specific sum (total).

Really appreciate any suggestions.

Thanks,

Dominic

3 Replies
Arjunarao
Honored Contributor II

Re: Daily transactions made by individuals in consecutive months

Can you attach the sample data with qvw to demonstrate your requirement? Thank you.

Not applicable

Re: Daily transactions made by individuals in consecutive months

Hi, can't really share sample but i have created demo:

   

UIDTransaction_amountDate
1234102015-08-01
123452015-07-02
1234202015-06-15
1234402015-04-20
1234152015-01-10
123452015-02-04

So as you can see the specific UID in the last 6 months has transacted the sum amount of 35 in 3 consecutive months.

So the expression needs to be 6 months back from current date with distinct UID sum of transaction_amount which >= 30 in a 3 consecutive month period.

Hope this makes sense.

Not applicable

Re: Daily transactions made by individuals in consecutive months

Hi, just wondering if you are still able to help?

Thanks.