6 Replies Latest reply: Dec 24, 2012 2:15 AM by Kaushik Solanki RSS

    Set Analysis Question

      Hi Everyone!
      I am a new user of Qlikview and I am currently working on a project where I need to use set analysis to make certain selections based on the fields. The fields I'm concerned with at the moment are File_Date_1 and Service Dt.
      I'm attempting to select the records where these two are equal and so initially, I tried just setting the two fields equal to each other however that did not work. I then tried creating a variable based off of Service Dt called vServiceDate.
      The syntax I used then was this:
      File_Date_1={"$(=date($[Service Dt],'M/D/YYYY'))"}
      Unfortunately, this does not work for me. Does anyone have any suggestions?