topic Set Analyis and datses in QlikView

Set Analyis and datses

qlikviewaf — Fri, 03 Aug 2018 12:58:47 GMT

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:

=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 — Fri, 03 Aug 2018 13:01:18 GMT

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

kfoudhaily — Fri, 03 Aug 2018 13:51:24 GMT

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,