topic Re: Using Addmonths in IF Statement for Dimension in QlikView

Using Addmonths in IF Statement for Dimension

Anonymous — Sat, 16 Nov 2024 05:13:29 GMT

Hi,

I use this if statement but it does not bring back 2 months, it brings back all available months in a Year.

if(date#(GLPeriod.PeriodNameRP,'MMM-YY') >= $(=addmonths(date#(only(GLPeriod.PeriodName),'MMM-YY'),-2))
,date#(GLPeriod.PeriodNameRP,'MMM-YY'))

Please let me know if i did any wrong.

Thanks

Dev

Re: Using Addmonths in IF Statement for Dimension

shwethaa — Fri, 16 Nov 2018 13:06:24 GMT

Hi Dev,
Try below expression
if(Date(date#(GLPeriod.PeriodNameRP,'MMM-YY')) >= Date(addmonths(Date(date#(Min(GLPeriod.PeriodName),'MMM-YY')),-2))
,Date(date#(GLPeriod.PeriodNameRP,'MMM-YY')))

-Shwetha A

Re: Using Addmonths in IF Statement for Dimension

Anonymous — Fri, 16 Nov 2018 13:18:23 GMT

Nope, it gives Error in Calculated Dimension. But the window says Expression is Ok.

Re: Using Addmonths in IF Statement for Dimension

Anonymous — Fri, 16 Nov 2018 14:42:58 GMT

It worked when i created the function as variable
vMonth5 variable is set with =addmonths(date#(only(GLPeriod.PeriodName),'MMM-YY'),-5)
and in IF
=if(date#(GLPeriod.PeriodNameRP,'MMM-YY') >= vMonth5
,date#(GLPeriod.PeriodNameRP,'MMM-YY'))