Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ksomosera10
Contributor II

Create a Custom Subtotal at Bottom

Hi,

Good day.

I was wondering if I can create a custom Subtotal for my Pivot Table.

Here's an example:

I have (5) columns named: Continent, Country, Sales 2018, Sales 2017, Percentage Diff.

I want to have a total sales for column "Sales 2018" and "Sales 2017"

at the same row where the Subtotal was, I want to calculate the percentage for sum of Sales 2018 and Sales 2017.

Capture.JPG

I hope I've make myself clear.

Please feel free to ask me for clarification.

Thanks in advance for your help!

3 Replies
Partner
Partner

Re: Create a Custom Subtotal at Bottom

Kevien

You can use rowno() in your expression  to get costume subtotal.

for more details follow below link.

https://www.qliktastic.com/2016/03/03/qlikview-pivot-table-average/

Raman

vishsaggi
Esteemed Contributor III

Re: Create a Custom Subtotal at Bottom

May be use a dimensionality() function. Can you post a snapshot of your output I mean your pivot table snapshot. ?

Ref Check here:

Dimensionality for custom subtotal in pivot table

ksomosera10
Contributor II

Re: Create a Custom Subtotal at Bottom

Capture.JPG