Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad_dumbre
Partner - Creator
Partner - Creator

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

11 Replies
ali_hijazi
Partner - Master II
Partner - Master II

unfortunately this cannot be done in QlikView so far

I can walk on water when it freezes
saumyashah90
Specialist
Specialist

Hi This may help you

1.png

ali_hijazi
Partner - Master II
Partner - Master II

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

I can walk on water when it freezes
saumyashah90
Specialist
Specialist

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

Not applicable

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

check this and try again.

Anonymous
Not applicable

Hello,

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

BR

Serhan

jpenuliar
Partner - Specialist III
Partner - Specialist III

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

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
Master III
Master III

Check this

145794.png