Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Date Comparision Greater Than Another Field

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!

Labels (1)
1 Reply
tresB
Champion III
Champion III

Try like this:

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