Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Set Analyis and datses

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!

2 Replies
sunny_talwar

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

kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant