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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YearToDate Calculation

How to do a YTD calculation?

If you look at the table below, basically i have 3 fields, Period, BudgetAmount & ActualAmount.

How to do an expression to calculate the yeartodate on budget and actual?

Untitled.png

4 Replies
Not applicable
Author

for budget ytd paste the same exp as budget amount and check full acumulation

Not applicable
Author

But its grey'd out?

Not applicable
Author

send small sample app

i'll check

Not applicable
Author

thanx just got it right, its in a pivot, ended using rangesum