Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
priyalvp24
Creator
Creator

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
sunny_talwar

May be see here

P&L for Sense?

petter
Partner - Champion III
Partner - Champion III

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