Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtracting rows in pivot table

Hi everyone,

I was about to create a sort of "income statement" (profit and loss) in qlik Sense. I tried the extension P&L Smart, but it is actually too limited for what I meant to do. A pivot table, instead, might suit better. However, before starting, I wanted to know whether it is possible to subtract two specific rows in a pivot table, and if yes, how.

I know it's possible to create a P6L Statement in View, but I don't find any material related to Sense.

e.g. I have

Operating revenues

Operating expenses.

I want to create a new row, say, Gross Profit, that is "Operating revenues"-"Operating expenses".

Thanks in advance.

10 Replies
Not applicable
Author

Thanks for your help. Anyway, I finally managed to follow this guide

https://community.qlik.com/docs/DOC-3324

and adapt everything to QlikSense.

After some work, here's the result. (please see attachment).