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

Set Analysis Question

Ben Brunette
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?