Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Thank you in advance for your help regarding my question and I apologize in advance if the question is a bit confusing but here I go... :
I have a Financial report that has "Plug rows" to arrive to the totals on the Chart of accounts. In the Example Bellow Cells A2 to C5 Have the Data as I needed to look in the data model.; Row 4 needs to be a calculated input Qlik does ( do not want to manipulate data in excel) that makes the total sum of the assets = to 500.
I hope my question makes sense.
Thank you all again.
Hi,
I think you are looking for a measure with a set expression that should look something like this:
sum({<Account={1000}>} Actual) - sum({<Account={1001,1002}>} Actual)