Discussion Board for collaboration related to QlikView App Development.
I've been trying to figure this out and have been unsuccessful. Hopefully someone can help
The following date range is not working and I'm not sure why.
Set vFM2 = 10 ;
Date(Date#(fYear & $(vFM)-3,'YYYYMM'),'YYYYMM') as fStartYear,
Date(Date#(Year + If(Month<$(vFM2), 1, 0)& num(Month,'#00'),'YYYYMM'),'YYYYMM')as EndMonth,
Date(Date#(AcctPeriod,'YYYYMM'),'YYYYMM') as AcctPeriod,
Thanks in advance
Are the figures wrong or you getting any error? Can you share a sample file to look into? Also tell us your expected output?
what about date formats?
possible to share data sample?