4 Replies Latest reply: Nov 10, 2014 3:05 AM by Jeroen Jordaan RSS

    SET Flag on Oldest Price in price changes table

    Jeroen Jordaan

      Hello QlikView addicts,

       

      I have a question. I want to create a flag for the oldest price.

      I have the following situation.

       

      Ik have a QlikView table called Item with all item related inotmation.

      linked to the item table (field association) I have a tabel with all the price changes per item. An item can have multiple price changes during a certain time.

       

      I want to set a flag (1) on the row of the oldest modification date per item.

       

      What's is the best way to do it.

       

      Does anyone has an example that would help me.

       

      Thanks in advance