Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

priyalvp24
Contributor

How to do subtotal in Qliksense?

Hi All,

How we can achieve the subtotal in qliksense Table.

e.g. My Fields are Gross sale,Discount,Cogs.

I want sub total as net sale i.e. Gross sale-Discount

Gross profit i.e. net sale -cogs.

Header 1Header 2
Gross sale100
Discount10
Net Sale(Sub Total As Gross sale - Discount)90
Cogs30
Gorss Profit( Sub Total as Net Sale- Cogs)60

Please Help.

Regards...

Priyal

2 Replies
MVP
MVP

Re: How to do subtotal in Qliksense?

May be see here

P&L for Sense?

MVP
MVP

Re: How to do subtotal in Qliksense?

You can find a recent solution to this along with how you can also format the table easily in this solution:

Adding manual rows in a P&L table in Qlik Sense

Community Browser