Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikViewStartup
Contributor
Contributor

Expression

thanks

2 Replies
jwjackso
Specialist III
Specialist III

If Date_Vsn_Sourc_New_Mem_Pgm is the date that program began, try something like this:

 

sum ({<[FISCAL_YEAR_NUMBER]={'$(vCurr_Yr)'},[VS_New_Member_Program]= {'Y'},[PROD GROUP] = {'ABCD','ABCD','ABCD'},[TYPE] = {'AB'},INVOICE_DATE={">=Date_Vsn_Sourc_New_Mem_Pgm<=$(=Monthend(=AddMonths(Date_Vsn_Sourc_New_Mem_Pgm,3)))"}>}QTY))

Not tested 

QlikViewStartup
Contributor
Contributor
Author

Thank you.