topic Re: Additional summary rows on a QlikView table in QlikView

Additional summary rows on a QlikView table

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I'm new to QlikView.

I built a table with daily total orders received and shipped by day for the selected month.

A summary row automatically appears and provides totals for the month.

I want to add a second summary row with Averages right below the totals.

How does one create an additional summary row that aligns to the rest of the table?

Thank you for taking the time.

Re: Additional summary rows on a QlikView table

vcanale — Wed, 27 Jul 2016 16:11:03 GMT

Hi James,
I'm not sure if it's possible to add an additional raw in the table, but you can choose in the Chart Properties to have the Average instead of the Sum.. See printscreen:

Or if you need both or more you can have a look at the Statistic Box and see if it's suitable for your needs.

Hope this can help

Regards

Re: Additional summary rows on a QlikView table

sunny_talwar — Wed, 27 Jul 2016 19:35:57 GMT

You can use Pick(Match()) with an Island table or you can use a synthetic dimension to do this.

Look at something similar done here (for a chart, but can be done for a table as well): Re: Subtotals and multiple dimensions in a barchart

Re: Additional summary rows on a QlikView table

Wed, 27 Jul 2016 20:55:41 GMT

Hi Sunny,

Thank you for the insight. I will give this a try.

Re: Additional summary rows on a QlikView table

Amir_h_Aghajani — Sun, 03 Jan 2021 08:00:28 GMT

Thank you. The answer was clever. You saved my time. I was thinking to switch to SSRS.