Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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).