Set Analysis Question

[#1]

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?

Thanks!

[#2]

=sum( {<File_Date_1= {"<=$(date($[Service Dt],'M/D/YYYY'))"}>} Sale)

May be this is help You

[swuehl]

You need to create a search expression that will do the record based comparison of File_Date_1 and Service Dt for you. Try something like

File_Date_1 = {"=File_Date_1=[Service Dt]"}

within your set expression (used inside an aggregation function and with the enclosing brackets, right?).

[#4]

Hi,

Please make sure that both of the dates are in same format once you compair them.

Hope this help,
Anosh

[Anonymous]

Hi,

Is there only one value for Service Dt ? Or is it related to the dimension?

You can try these:

File_Date_1={"=$(=date('$(vServiceDate)','M/D/YYYY'))"}

File_Date_1={"=$(=only([Service Dt],'M/D/YYYY'))"}

Dilyana

[#6]

Hi Ben

Did you get an answer to this? I have the same exact issue and would love to know if you have a solution.

Thanks

Eric

[kaushiknsolanki]

Hi Eric,

     Will you please start a new discussion and describe your exact problem. What you want and what you did till now.

     If possible post QVW file with some sample data.

Regards,

Kaushik Solanki