Solved: How to find last 3 Sales of the customer when ent... - Qlik Community

rkpatelqlikview · ‎2017-12-08

Hi All,

Can anyone help on this?

How to find last 3 sales of the customer once i enter the customer id?

Example: Entered Customer Id is A202.

I need last his sales

100+200+300 =700.

How to solve this? Thanks in advance

sunny_talwar · ‎2017-12-08

When you say entered, do you mean when you select a particular customer id?

May be this:

Sum({<Date = {"$(='>=' & Date(Max(Date, 3), 'DD.MM.YYYY'))"}>}Sales)

sunny_talwar · ‎2017-12-08

When you say entered, do you mean when you select a particular customer id?

May be this:

Sum({<Date = {"$(='>=' & Date(Max(Date, 3), 'DD.MM.YYYY'))"}>}Sales)

rkpatelqlikview · ‎2017-12-08

Thanks Sunny

How to find last 3 Sales of the customer when entering the Customer ID