2 Replies Latest reply: Oct 23, 2013 1:09 PM by Tresesco B RSS

    Unique combination of fields

    Erik van hout

      My qlikview-file exists of 1 big table.

      In this table a combination of fields should be unique.(However the input has to be correct)

      What would be a good way to check if a combination of fields within a table is indeed unique?

       

      Let's say I want t check if the combination of the fields:

      [Date], [department], [activity], [uom]

      is unique at the time the script is reloaded