Set Analysis - range dates

[qlikviewaf]

Hi Guys,

i'm trying to create this range for Surgery Date using a variable (the one in bold).

i tried several times but is not working... how i can fix this?
Thank you!!

if(Match([SalesRepException],'I22') AND SurgeryDate>=($(vStartI22)) AND SurgeryDate<=($(vStartI22)+365),'30',

[timothyj]

Did you try adding single quotation marks?

if(Match([SalesRepException],'I22') AND SurgeryDate>=('$(vStartI22)') AND SurgeryDate<=('$(vStartI22)'+365),'30',

Also try using AddMonths instead of +365.

if(Match([SalesRepException],'I22') AND SurgeryDate>=('$(vStartI22)') AND SurgeryDate<=AddMonths('$(vStartI22)', 12),'30',

[Davis25]

Set analysis offers a way of defining a set (or group) of data values that is different from the normal set defined by the current selections. Normally, when you make a selection, aggregation functions, such as Sum, Max, Min, Avg, and Count aggregate over the selections that you have made: the current selections.

www.mycardstatement.com