Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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