Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am having an issue with trying to add in some calculated subtotal rows for my Qlik Sense Pivot Table I have a table with Income, Expense, Other Income, and Other Expense. I would like to add in a Total Income Row (=Income + Other Income), a Total Expense Row (Expense + Other Expense) and an NOI Row (Total Income Row - Total Expense Row). I have accomplished this by using ValueList() function, but now my rows, when expanded, includes all the other accounts as well even though they are 0 values. Attached are screenshots that may better explain. Thanks in advance for any help.
After playing with this for a long time, I was able to solve it by utilizing the ValueList() and then creating an excel pivot table and filtering out the 0 values.