Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-01-19 03:09 AM

YTD calculation

i have the following code to calculate amount

=IF( ValueLoop(1,12,1)=1 ,num(sum({$<Network={1},Src={1},BillMonthNo={'<=$(vBillMonthNo)'} >}Amount),'R # ##0,00')....

this code works wneh nothing on BillMonth is selected therefore vBillMonthNo=12 so everything is calculated

but wen i select a month say Nov my vBillMonthNo becomes 11 but now it only calculates for one month

please assit

171 Views
0 Likes
0 Replies