4 Replies Latest reply: Apr 3, 2013 4:04 PM by Benjamin Dykstra RSS

    Flagging based on Null Values/Max Date

      Hello Qlikview Community:

       

      I am trying to create a flag that marks items as distinct in our plan-o-gram. I need to add logic below that first looks for a null value in the inactive_date field, and if there is no null value, then it should look for the max date in that field.

       

      Here is what I have so far:

       

      POGTemp:

      Load Distinct

           Store_Number,

           Sku_Number,

           Customer_Number,

           Max(inactive_date)           as Max_Inactive_Date

           '1'                                   as Distinct_POG

      Resident CPMPOG

      Group By

           Store Number,

           Sku_Number,

           Customer_Number;

       

      Any help would be greatly appreciated.

       

      Regards,

       

      Ben D.