topic Set Analysis Question in QlikView

Set Analysis Question

Fri, 18 May 2012 14:31:34 GMT

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!

Set Analysis Question

Fri, 18 May 2012 14:38:59 GMT

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

May be this is help You

Set Analysis Question

swuehl — Fri, 18 May 2012 14:39:08 GMT

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?).

Set Analysis Question

Fri, 18 May 2012 14:41:45 GMT

Hi,

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

Hope this help,
Anosh

Set Analysis Question

Anonymous — Fri, 18 May 2012 15:18:15 GMT

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

Re: Set Analysis Question

Mon, 24 Dec 2012 07:11:13 GMT

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

Re: Set Analysis Question

kaushiknsolanki — Mon, 24 Dec 2012 07:15:13 GMT

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