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: 
rwb139
Creator
Creator

Pivot Table Adding Calculated Rows

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. 

1 Reply
rwb139
Creator
Creator
Author

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.