6 Replies Latest reply: Oct 3, 2017 9:56 AM by Elizabeth Oram RSS

    Issue with variable in Qlik Sense

    Elizabeth Oram

      I'm trying to use a variable to check whether or not a certain value exists in a field.

       

      This is what I have:

       

      Let vArchive = If(Match('Archive', 'ArchiveCost'), True(), False())

       

      Archive is a field in a table, and I'm checking to see if ArchiveCost exists as a value.

       

      Right now, it returns False even when the value does exist. Is there a better way to do this than the Match() function?

       

      Thanks!