Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

Re: Showing Dynamic "Total Label"

unfortunately this cannot be done in QlikView so far

I can walk on water when it freezes
Highlighted
Specialist
Specialist

Re: Showing Dynamic "Total Label"

Hi This may help you

1.png

Highlighted
Partner
Partner

Re: Showing Dynamic "Total Label"

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

I can walk on water when it freezes
Highlighted
Specialist
Specialist

Re: Showing Dynamic "Total Label"

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

Highlighted
Not applicable

Re: Showing Dynamic "Total Label"

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

check this and try again.

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Creator III
Creator 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

Highlighted
Master III
Master III

Re: Showing Dynamic "Total Label"

Check this

145794.png