5 Replies Latest reply: Feb 14, 2018 7:56 AM by Sunny Talwar RSS

    Restrict Dimension by max(Date)

    Tom Müller

      Dear all,

       

      I have Excel-data, that looks like this:

       

      ProjektRechnungsdatumName
      101.01.20181. Rechnung
      102.01.20182. Rechnung
      108.01.20183. Rechnung
      231.01.20181. Rechnung

       

      The result (just a usual table in QLIK) shall look like this:

       

      ProjektRechnungsdatumName
      108.01.20183. Rechnung
      231.01.20181. Rechnung

       

      So I just want the latest data to be shown outgoing from the date of invoice (Rechnungsdatum). I thought about creating a dimension for "Name", but as I am missing a command as "for" I don't know how to do it. Would be great if you can help.

       

      Greetings,

       

      Tom Müller