topic Re: Set Analysis - range dates in QlikView

Set Analysis - range dates

qlikviewaf — Wed, 01 Dec 2021 14:43:31 GMT

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',

Re: Set Analysis - range dates

timothyj — Wed, 01 Dec 2021 17:35:14 GMT

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',

Re: Set Analysis - range dates

Davis25 — Fri, 03 Dec 2021 09:27:00 GMT

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.