topic Label for Totals Expressions in Pivot Table in QlikView

Label for Totals Expressions in Pivot Table

Thu, 23 Jul 2009 12:39:59 GMT

Hi All,

Please see the attached screenshot below for the pivot table in question.

I'd like to add labels at each level instead of the 'Total' currently shown.

The total for the Account column should show the NetAssetGroup, likewise the total line under the Activity column should show the Account group. I've tried various formula, only succeeding when selections are made.

The text should display when no selections are made.

Thanks in advance.

Label for Totals Expressions in Pivot Table

Thu, 23 Jul 2009 13:39:16 GMT

Hi,

If i would of understood your question properly and if you want the output which is in the attached image.

Then right click on the object and Property -- > Presentation --> Dimensions & Expression and choose the dimension which you want to Lable and give your labe in Label for totals.

This should help you.

- Sridhar

Label for Totals Expressions in Pivot Table

Thu, 23 Jul 2009 14:04:53 GMT

Hi Sridhar,

Unfortunately it's not that simple, sorry I hadn't made it clear.

See how in the attached picture I have given the name of the parent group to the Total Label on the Partial Sum rows.

This is what I want to achieve on my Qv pivot table.

Label for Totals Expressions in Pivot Table

kji — Thu, 23 Jul 2009 15:21:29 GMT

This is currently not possible to achieve since the formula for the total label is calculated on the current selection state and not iterated over the chart dimensions (ie you get the same thing you would get if you put that formula in a text object).

Label for Totals Expressions in Pivot Table

johnw — Fri, 24 Jul 2009 05:22:18 GMT

As an alternative that is similar to what you want, have you tried selecting Indent Mode on the Style tab? That then displays the totals on the same line as "Assets" and so on, making it perhaps more clear what the totals are referring to, even if they aren't laid out exactly like you've asked for. You can select whether you want those totals at the top or bottom as well.

Label for Totals Expressions in Pivot Table

Fri, 24 Jul 2009 08:03:19 GMT

Thanks Johan and John.

I'll present the indent option as an alternative.

Label for Totals Expressions in Pivot Table

Mon, 27 Jul 2009 14:58:04 GMT

This can be possible, please refer the attachment you will get some idea.

Valan

Label for Totals Expressions in Pivot Table

mkl — Wed, 16 Dec 2009 15:25:29 GMT

Hi Johan,

I read this comment You have done last summer concerning the label for totals in pivot tables. I have similar case in one customer at Finland to solve

but we haven't either find a solution to generate dimension values to label for columns in software current version. Do You have any further information concerning this issue?

Kind regards,

Mikko Kuusela

QlikTech Finland

Label for Totals Expressions in Pivot Table

Fri, 15 Jan 2010 18:03:38 GMT

Has any one worked out a solution to this problem?

Label for Totals Expressions in Pivot Table

Tue, 06 Mar 2012 21:41:39 GMT

Is there any resolution to this problem?

Re: Label for Totals Expressions in Pivot Table

agigliotti — Fri, 15 Feb 2013 14:28:10 GMT

Hello All,

Currently I'm using the latest version 11.20.11705 and the problem has not been fixed yet.

When we can expect to be fixed ?

Re: Label for Totals Expressions in Pivot Table

agigliotti — Fri, 15 Feb 2013 14:29:33 GMT

any good news about the issue???

Re: Label for Totals Expressions in Pivot Table

agigliotti — Fri, 15 Feb 2013 14:32:04 GMT

Hi John,

any good news from QlikTeck about this missing functionality ?

Re: Label for Totals Expressions in Pivot Table

Thu, 14 Aug 2014 11:10:15 GMT

You Can use the Indent mode with a text concatenated with the dimension to get close to the requirement.

Re: Label for Totals Expressions in Pivot Table

tyagishaila — Fri, 20 Feb 2015 07:22:28 GMT

Hi Rupas,

Could you please attach .qvw for your solution.

Thanks,

Shaila

Re: Label for Totals Expressions in Pivot Table

Wed, 25 Mar 2015 10:24:08 GMT

Hi Shaila,

Do you still need thee qvw or did you figure out how this is done?

Regards,

Rufus Lopes

Re: Label for Totals Expressions in Pivot Table

tyagishaila — Wed, 01 Apr 2015 13:27:00 GMT

Sorry for late reply

I was not active on community from last 2 3 weeks,

I have done it

Thanks for All

regards,

Shaila

Re: Label for Totals Expressions in Pivot Table

Wed, 01 Apr 2015 13:34:38 GMT

Could you please close the thread by selecting the correct answer or post the correct solution?

Re: Label for Totals Expressions in Pivot Table

tyagishaila — Tue, 07 Apr 2015 06:14:55 GMT

Hi Rupas,

Here is no option available for Helpful/Correct Answer.

I am able to click on Like only.

Thanks,

Re: Label for Totals Expressions in Pivot Table

psankepalli — Fri, 21 Oct 2016 19:50:50 GMT

Hi Saila,

I am looking for the same answer, can you please update the solution and mark it as answer. so that everyone can find the answer

Thanks