Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
qv_testing
Valued Contributor II

problem with total label in pivot table

Hi Community,

I have a pivot table, which shows partial sums for the third dimension i.e Month-Year.

Total label showing twice.

Capture.PNG

Thanks in Advance...

19 Replies
Highlighted
Sergey_Shuklin
Valued Contributor

Re: problem with total label in pivot table

Hello, Raju!

Name the first total as "total" and the second total as ' '.

Highlighted
qv_testing
Valued Contributor II

Re: problem with total label in pivot table

Sorry, i didn't get you.

Highlighted
neha_shirsath
Valued Contributor

Re: problem with total label in pivot table

This is coming 2 times because it consider Month year and sub product row wise so for both it shows differently Total field.

Highlighted
qv_testing
Valued Contributor II

Re: problem with total label in pivot table

Yes, i understand that.

but, how to get rid of that.

Highlighted
neha_shirsath
Valued Contributor

Re: problem with total label in pivot table

I think we will not removed 1 because removing of one total text, its removing both so better way you need to do some extra thing like you can take text object and keep on 1 Total to hide that.

Highlighted
qv_testing
Valued Contributor II

Re: problem with total label in pivot table

if users select any value, it will reduce chart, it will appear again.

That is not correct way.

Highlighted
Not applicable

Re: problem with total label in pivot table

Hi,

The issue is due to subtotal enabled for Month-Year and the dimension is placed below the expression name.

Screen shot for this explanation is given below.

When Month-Year is shown horizontally and below expression name.

When Month-Year is given above the expression names.

In the bottom screen shot you see only 1 total.

In the above screen shot it shows 2 total, top Total is for expressions and bottom Total is for Month-Year.

Hope it helps

Highlighted
qv_testing
Valued Contributor II

Re: problem with total label in pivot table

I know that, problem is, if i drag up my dimension, users always scroll to see totals.

they need to see each level sub totals.

Highlighted
qv_testing
Valued Contributor II

Re: problem with total label in pivot table

Experts, anyone can help me.