Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

varaible portts in script.

Hi, I have the below enclosed report in which I am using a calendar objects for start date and end dates for date range selection.

In the expression below,TRANS_ID_MAX is taken as max(GC_TRANS_ID) in the script but I want to restrict this max(GC_TRANS_ID) to be <=VENDDATE(the varaible used for calendar object basically the enddate which is the max of date range in the calendar object.).Is there a way to do this.How to use the varaible ports in script or pls suggest if theres any other way to do this.

sum({$<STORE_NUMBER={'SVS*'},GC_BUY_OR_REDEEM={B},
CALENDAR_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'}>}
if(GC_TRANS_ID=TRANS_ID_MAX,
GC_BALANCE))

Thanks,

Swetha



1 Reply
Highlighted
Not applicable

Any updates pls.