
Contributor
2019-07-02
02:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression
thanks
- Tags:
- qlikview_deployment
430 Views
2 Replies

Specialist III
2019-07-02
04:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
398 Views

Contributor
2019-07-03
10:19 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you.
384 Views
