Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie
Contributor II
Contributor II

Aggregation in straight table

 

I have a requirement where I need to calculate total number of transactions for last 60 days keeping row transactions date as reference and then identify the transaction more than 3.

Customer,Date, amount,type
C1,01/01/2019,100,w
C1,26/01/2019,200,w
C1,02/02/2018,111,d
C2,01/05/2019,357,w
C2,04/05/2019,568,w
C3,09/03/2019,45,d

For each row I need total transactions happened in last 60days

E.g. for row 1 I need to get total transactions happened between 01/01/2019 and "date(01/01/2019) -60" i.e 2
Similarly for row 2 I need to get total transactions happened between 26/01/2019 and "date(26/01/2019) -60" i.e 1

Then finally show the records having 3 or more transactions.

3 Replies
sunny_talwar

Why is this only done for the two dates? Why no for 01/05/2019 or 02/02/2018?

Newbie
Contributor II
Contributor II
Author

It has to be done for all records.I have given example of first two rows

sunny_talwar

I think the best way to do this would to be use The As Of Table