Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jjking58
Contributor III
Contributor III

Set analysis

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

2 Replies
vishsaggi
Champion III
Champion III

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
Partner - Creator III
Partner - Creator III

what about date formats?

possible to share data sample?

QlikView Qlik Sense consultant