3 Replies Latest reply: Nov 2, 2017 6:15 AM by Nina Iren Jensen RSS

    How to set specific critera for which rows to display?

    Nina Iren Jensen

      Hi all,

       

      In Qlik Sense I have a table where I would like to show only specific rows.

      In the table below I would like to show only the rows with the last Sale nr per date per Name. I have tried FirstSortedValue, but that  only showed the highest value in column Sales nr, disregarding the Name.

       

      Here is an example of how my table could look:

      Name (dim)Date (dim)Hour(dim)Sale nr (measure)
      James21-10-201710:451
      James21-10-201711:352
      Colin21-10-201708:301
      James21-10-201712:343
      Colin21-10-201709:102
      Colin21-10-201714:403
      James21-10-201713:004
      James22-10-201708:001
      Colin22-10-201709:301
      Colin22-10-201710:152
      James22-10-201709:002
      James22-10-201710:003

       

      This is how I want it to look:

      NameDateHourLast Sale nr
      James21-10-201713:004
      Colin21-10-201714:403
      James22-10-201708:003
      Colin22-10-201710:152

       

      If anyone could help me out with this it would be much appreciated as I do not know how to set up this expression (or script).

       

      Regards.

      Nina