topic Re: Showing Dynamic "Total Label" in QlikView

Showing Dynamic "Total Label"

prasad_dumbre — Mon, 15 Dec 2014 13:08:33 GMT

Dear Experts,

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

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

like below image:

Is it possible ???

Thanks in advance . . .

Regards,

Prasad D. Dumbre

Re: Showing Dynamic "Total Label"

ali_hijazi — Mon, 15 Dec 2014 13:10:48 GMT

unfortunately this cannot be done in QlikView so far

Re: Showing Dynamic "Total Label"

saumyashah90 — Mon, 15 Dec 2014 13:28:30 GMT

Hi This may help you

Re: Showing Dynamic "Total Label"

ali_hijazi — Mon, 15 Dec 2014 13:46:41 GMT

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

Re: Showing Dynamic "Total Label"

saumyashah90 — Mon, 15 Dec 2014 14:01:26 GMT

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

Re: Showing Dynamic "Total Label"

Mon, 15 Dec 2014 14:58:10 GMT

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

check this and try again.

Re: Showing Dynamic "Total Label"

Anonymous — Mon, 15 Dec 2014 15:15:23 GMT

Hello,

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

Serhan

Re: Showing Dynamic "Total Label"

jpenuliar — Mon, 15 Dec 2014 16:06:24 GMT

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

Re: Showing Dynamic "Total Label"

pljsoftware — Mon, 15 Dec 2014 16:45:00 GMT

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

Re: Showing Dynamic "Total Label"

anbu1984 — Tue, 16 Dec 2014 05:44:31 GMT

Check this

Re: Showing Dynamic "Total Label"

prasad_dumbre — Tue, 16 Dec 2014 06:02:13 GMT

Hi Anbu,

Thanks for your feedback.

Can you guide how can we do similar with more dimensions, as i tried your approach but i got output like this

I want last line label "India Total: 12".

Is it possible ?

Re: Showing Dynamic "Total Label"

anbu1984 — Tue, 16 Dec 2014 06:17:35 GMT

Yes. Try this

If(Dimensionality() =2, Currency & ' Total : ' & Sum(Sales),If(Dimensionality() =0, Market & ' Total : ' & Sum(Sales),Sum(Sales)))