This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
a bit of background:
each month we take a snapshot of our open backlog (that might have changed to due different changes in orders)
so, we would like to compare the snapshot to the "calculated" (that will take the first snapshot and + Bookings - Revenues)
i am looking to create the following table:
to make it easier, i am even ok with setting the first month (jan) with a fixed number
the following calculation gives me the correct answer for the first row
If(Year=2021 and Month='Jan', SUM(Backlog),Above(Sum(Backlog))+sum(Bookings)-sum( Revenues))
but after that i guess i need some kind of recursion or else it takes the Above(Sum(Backlog))
instead of the entire function
How about something like;
Shown in here with the parts broken out;
View solution in original post
Thank you Chris! 🙂