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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

(Qlick SenseCloud) Cumulative total aggregation (set expression)

Hello all,

I stuck with simple task:

task.png

Please help me with formula, how I can get cumulative total summarizing current period result and previous period results.

I suppose it should be using set expression, like:

((sum({<Week = {"<=$(Week)"}"}>}(Income-Outcome)),

but it doesn't work (((

Thank you in advance!

Regards,

Tima

0 Replies