topic Re: Pivot Table Total custom Label in QlikView

Pivot Table Total custom Label

Anonymous — Wed, 13 Aug 2014 03:19:01 GMT

Hi,

I have attached a snaphot of a Pivot Table,,

In my report format, I want the Total label to be the same as the first column grouping...

Is it possible? Ive tried to explore making the total label as an expression but its not giving any value..

Many thanks for the assistance....

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 04:59:59 GMT

Hi nald_p56,

can u please elaborate it???

Re: Pivot Table Total custom Label

Anonymous — Wed, 13 Aug 2014 05:03:09 GMT

hi,

In my attached pic

In the second column there is Major Total for every Major,,

Is there a way to make the Total label as "Accounting Total", "Corporate Communication Total"

Thanks.

Re: Pivot Table Total custom Label

vardhancse — Wed, 13 Aug 2014 05:06:16 GMT

Are you trying for sub totals for every row.

Chart Properties->Presentation->Select all the dimensions->Select 'Show Partial Sums'

For every row you can see the Total

Re: Pivot Table Total custom Label

Anonymous — Wed, 13 Aug 2014 05:10:30 GMT

hi,

yes, i already did that... the probem is that the total label is generic...

the picture that i sent is already from Qlikview,,, for every row total..

the label is Field Name Total..

so in my example, its showing Major Total, because im showing the total for every major..

is there a way to show in the label "Accounting Total",, the corresponding value of the major?

Re: Pivot Table Total custom Label

vardhancse — Wed, 13 Aug 2014 05:13:20 GMT

So you are trying a unique label for each row.

I don't think so that we have such option in QlikView.

Re: Pivot Table Total custom Label

avinashelite — Wed, 13 Aug 2014 05:15:25 GMT

Hi Nald,

Its not possible in Qlikview.

Regards,

@vi

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:18:33 GMT

As per me also this is not possible in QV

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:24:53 GMT

Hi,

As i have understood you want to change the name of TOTAL.

This can be done by:

Properties>Presentation>Click on the desired dimension for which you are showing total value>Label for Totals and Pt the name as you like.

Hope it helps

Thanks

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:28:06 GMT

Dear Ankit,

This will give the same label to all the values of the dimension. But the requirement here is to have different label for each dimension value

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:32:42 GMT

Dear Saima,

I think we can give different names to all the dimensions we have.Just select the desired dimension and on Option 'Label for Totals' we can give the name as per our requirement.

Thanks

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:36:19 GMT

Hi,

Can you share a file.That will help understanding the exact requirement.

Thanks

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:38:05 GMT

Yeah but that is for each dimension.... N we need seperate labels for each value in the dimension. For Eg: if you have a field Name having 3 values ABC,XYZ,DEF so you should be able to give the total label as ABC Total, XYZ Total, DEF Total.....

Re: Pivot Table Total custom Label

Anonymous — Wed, 13 Aug 2014 05:42:49 GMT

so its really not possible...

Thanks evryone,,, i love this community... very alive and helpful 😃

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 05:44:53 GMT

Hi,

I think that won't be possible however you can use a Text Box with the name as per requirement and fix that e accordingly.If that helps.

Thanks

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 06:00:48 GMT

But placing textbox wont help since the table might change with each selected filters

Re: Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 06:19:16 GMT

Hi,

PFA...Try This.

Thanks

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 06:26:08 GMT

Kewl....

Thats upon the selection... what if one needs without selecting...????

Then it would be next to impossible

Re: Pivot Table Total custom Label

Wed, 13 Aug 2014 06:41:09 GMT

Unfortunately this is the best we can do at the moment.

Re: Pivot Table Total custom Label

avinashelite — Wed, 13 Aug 2014 10:07:04 GMT

can you please close this thread and mark it as answered