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

    set analysis formula question

      Hi,

       

      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:

       

      =Sum({$<CUST_REGION={'A'},QTR_ID={'201302','201303','201304','201401'}>}SALES)-Sum({$<CUST_REGION={'A'},QTR_ID={'201302','201303'}>}SALES)

       

      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