Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

prasad_dumbre
Contributor

Showing Dynamic "Total Label"

Dear Experts,

As shown in below image, in pivote table, whenever we apply partial sum , label Total gets displayed

1.PNG

My Req. is it should show, that particular dimension value & ' Total' .

like below image:

2.png

Is it possible ???

Thanks in advance . . .

Regards,

Prasad D. Dumbre

Tags (3)
11 Replies
ali_hijazi
Honored Contributor

Re: Showing Dynamic "Total Label"

unfortunately this cannot be done in QlikView so far

saumyashah90
Valued Contributor

Re: Showing Dynamic "Total Label"

Hi This may help you

1.png

ali_hijazi
Honored Contributor

Re: Showing Dynamic "Total Label"

but in this case all Total labels will be Total Services URL's

saumyashah90
Valued Contributor

Re: Showing Dynamic "Total Label"

This was just an example...You can have name you want

Not applicable

Re: Showing Dynamic "Total Label"

Maybe your problem is that you have unchecked the property "Allow Pivoting".

check this and try again.

darkhorse
Valued Contributor

Re: Showing Dynamic "Total Label"

Hello,

You can only go for modifying your data and adding a total line in the script I suppose.

BR

Serhan

jpenuliar
Valued Contributor III

Re: Showing Dynamic "Total Label"

Hi Prasad,

it would seem that a solution is yet to be found regarding this requirement.

Here's a bit of workaround to your problem:

Label for Totals Expressions in Pivot Table

this thread has made use of Indent Mode

pljsoftware
Contributor III

Re: Showing Dynamic "Total Label"

Hello Prasad,

I made a similar thing to calculate total for region and country.

You need to add in Amount dimension some different values for new different total and every single total need to join each value of Amount.

For example, you have Amount 200, 300, 400 and you want USD Total, EUR Total and so on...

You need to create a new dimension TotalAmount where you have a link for

USD Total to 200, 300, 400

EUR Total to 200, 300, 400

....

More all single Amount value, so

200

300

400

....

in your table you put the new dimension TotalAmount

I hope this help you.

Regards

Luca Jonathan Panetta

anbu1984
Honored Contributor III

Re: Showing Dynamic "Total Label"

Check this

145794.png

Community Browser