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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0 Replies