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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

Partial Accumulation not Full

I am trying to do a running total at runtime for being able to dynamically update it on the charts and tables with the condition that if the month-year is greater than the current month-year (fiscalperiod) then the total should be 0.00 thereafter until end of year. Achievable in load script, it is posing some issues in the expression on the charts.

So far, I have an error in the PEEK() for some reason. Any help would be appreciated. Thanks.

=



SUM(IF(NUM(FiscalPeriod) < NUM(Year(TODAY()) & NUM(Month(TODAY()), 00)), (Revenue)/1000)) +

SUM(IF(NUM(FiscalPeriod) < NUM(Year(TODAY()) & NUM(Month(TODAY()), 00)),PEEK('Revenue')/1000))

Labels (1)
0 Replies