topic Re: Set analysis in QlikView

Set analysis

jjking58 — Wed, 19 Sep 2018 12:08:37 GMT

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.

sum({1<AcctPeriod={">=$(=fStartYear)<=$(=EndMonth)"}>}Amount)

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

vishsaggi — Wed, 19 Sep 2018 12:54:28 GMT

Are the figures wrong or you getting any error? Can you share a sample file to look into? Also tell us your expected output?

kfoudhaily — Wed, 19 Sep 2018 15:12:08 GMT

what about date formats?

possible to share data sample?