9 Replies Latest reply: Feb 28, 2014 4:14 PM by whiteline _ RSS

    set analysis formula question



      I'm a new user to Qlikview with little experience in writing formulas, so any help is much appreciated.  Here is what I'm trying to do:


      For a select population of customers, return those that have had no sales in the past 2 quarters, but have had sales in the 4 quarters prior.  Eventually, I would like to show what those sales were in the prior 4 quarters.


      I believe I can get the list of customers a roundabout way by the following formula, with customer name as the dimension:




      If a customer comes back with zero or negative sales, then they had no activity in the recent two quarters.


      However, I think there is an easier/more effective way using the p() or e() functions, but I just can't get it to work.


      Thanks - Matt