Set Analyis and datses

[qlikviewaf]

Hi,

i'm trying to define a formula as follow

WalkingImplantAsOf = is a variable where the user enter a date

I would like to have a sum where:

• the SurgeryDate is less or equal to the variable WalkingImplantsAsOf
• The InvoiceDate is greater than the variable WalkingImplantAsOf

=sum({<SurgeryDate={"<=$(=Max($(WalkingImplantAsOf)))"},Invoice_Date=IsNull or >=$(WalkingImplantAsOf)>}WI_EUR)

I'm trying the formula above but it's not working - can someone please help?
Thank you so much!

[sunny_talwar]

Would you be able to share a sample to show what all you have?

[kfoudhaily]

Hello,

as sunny said, an exemple might be helpfeull, but please check this expression;

// Calculate the Sum of "WI_EUR"

//      - Select records less than      "$(WalkingImplantAsOf)" in field "SurgeryDate"

//      - Select records greater than "$(WalkingImplantAsOf)" in field "InvoiceDate"

=Sum(

          {$<

          SurgeryDate=     { " <= $(WalkingImplantAsOf)" },

          InvoiceDate=      { " >   $(WalkingImplantAsOf)" }

          >}

          WI_EUR

)

regards,