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?