topic Re: Grand Total Pivot table in App Development

Grand Total Pivot table

joeybird — Tue, 13 Oct 2015 13:07:38 GMT

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

Re: Grand Total Pivot table

robert_mika — Tue, 13 Oct 2015 13:29:58 GMT

Is this your after?

JS Pivot Table for QlikSense

Re: Grand Total Pivot table

joeybird — Tue, 13 Oct 2015 13:44:42 GMT

Hiya

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

please help

Re: Grand Total Pivot table

joeybird — Tue, 13 Oct 2015 14:56:46 GMT

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

Re: Grand Total Pivot table

Tue, 13 Oct 2015 15:09:35 GMT

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

Re: Grand Total Pivot table

Michael_Tarallo — Tue, 13 Oct 2015 15:28:31 GMT

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

Re: Grand Total Pivot table

joeybird — Wed, 14 Oct 2015 07:26:24 GMT

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

Re: Grand Total Pivot table

joeybird — Wed, 14 Oct 2015 12:36:04 GMT

Hiya

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

thank you Andrew x

Kind Regards

Re: Grand Total Pivot table

Tue, 22 Aug 2017 18:56:59 GMT

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.