Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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).