5 Replies Latest reply: Nov 9, 2018 2:06 PM by Javier Power RSS

    QlikSense: Search in a table already loaded, if there is renewal of an Order

    Javier Power

      Good afternoon.

       

      I have a table that contains the history of Orders sold of different products. These Orders have an expiration date, after which, the Product must be renewed.

       

      How can I get information on whether the Product was Renewed, after the Expiration date?

       

       

       

      The fields that I have are:

       

      IdOrden: it is a unique value, it is not repeated

       

      Order Processing Date

       

      Expiration Date of the Order

       

      Unique Identifier of the Product (IUP): this field is repeated in the different registers of the same product (in the original order and in the successive renewals)

       

       

       

      Is there a function within the board that handles the tables created in the load, that allow me to do this?

       

       

       

      I appreciate the help you can give me.

       

      Greetings