Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Grand Total Pivot table

Hiya

I have lots of customers (Customer ID) that have orders under a department e.g  catering, finally  and sub specialties (plates)

I have a pivot table showing number of sales per month for year (2014) for each department, which you can expand to show the  sub specialties, number of sales

I would like to add a grand total column along the bottom for each month for each specialty

is this possible in qlik sense?

please help

1 Solution

Accepted Solutions
Not applicable

Re: Grand Total Pivot table

Not sure its possible in Qlik Sense pivottables - although I am keen to be corrected!

Only thing I can think to mimic it, is a normal table with static fields such as:

SUM(IF [Department]='Catering',[Sales])

then use a drill down Dimension to get Department>Sub-specialty etc.

It won't look the same as your pivottable, but might be sufficient

8 Replies

Re: Grand Total Pivot table

Is this your after?

JS Pivot Table for QlikSense

joeybird
Contributor II

Re: Grand Total Pivot table

Hiya

would like to use expression, as some extensions are not supported on future updates

please help

joeybird
Contributor II

Re: Grand Total Pivot table

Hiya

https://community.qlik.com/servlet/JiveServlet/showImage/2-257612-21630/Total.png

here is a picture from a previous post. I need to find out the expression how to get the BOTTOM total lines for each month

e.g where it shows total '110'

and main total  '150'

please help

Not applicable

Re: Grand Total Pivot table

Not sure its possible in Qlik Sense pivottables - although I am keen to be corrected!

Only thing I can think to mimic it, is a normal table with static fields such as:

SUM(IF [Department]='Catering',[Sales])

then use a drill down Dimension to get Department>Sub-specialty etc.

It won't look the same as your pivottable, but might be sufficient

Employee
Employee

Re: Grand Total Pivot table

Hello Joanna,

Is this for Qlik Sense?

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

joeybird
Contributor II

Re: Grand Total Pivot table

Hiya

the extension format is exactly what I need, but I am steering away from using extensions

please can the Qlik team develop the total bar for the current pivot table contained within qlik sense

Kind Regards 

joeybird
Contributor II

Re: Grand Total Pivot table

Hiya

I took on Board your idea, but I found best using a bar chart

thank you Andrew x

Kind Regards

Not applicable

Re: Grand Total Pivot table

Is it possible yet to generate a grand total line for measures in columns, for pivot tables?  I see the answer above is from 2015, so I'm hoping things have changed since then.

Thanks.