Set Analysis - Date Comparision Greater Than Another Field

Tue, 26 Nov 2013 17:36:15 GMT

Hello

I am looking for help with the following set analysis expression.

sum(

<SfdcOpptyID =

p({$<Snapshot.Date={$(=Num(vPickSnapshotDate_1))},Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}>} SfdcOpptyID) *

p({$<Snapshot.Date={$(=Num(vPickSnapshotDate_2))},Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}>} SfdcOpptyID)

,Snapshot.Date={$(=Num(vPickSnapshotDate_1))}

}

TotalPrice

)

The part of the expression that i have trouble is Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}

I created small test .qvw with few rows and it same logic (expression , syntax) works(attach). But if i try to implement this in my main report it does not return value. If i replace the logic to use IF statement then the report brings back numbers.

Please advise!

Re: Set Analysis - Date Comparision Greater Than Another Field

tresB — Wed, 27 Nov 2013 04:40:26 GMT

Try like this:

Closed.QuarterStartDate={"=Closed.QuarterStartDate<Snapshot.QuarterStartDate"}

topic Set Analysis - Date Comparision Greater Than Another Field in QlikView

Set Analysis - Date Comparision Greater Than Another Field

Re: Set Analysis - Date Comparision Greater Than Another Field