Pivot table sub totals help needed

[#1]

Hi All,

In my pivot table i have three columns,

Country	state	city
A	A1	A11
A	A1	A12
Total
A	A2	A21
A	A2	A22
A	A2	A23
Total
B	B1	B11
B	B1	B12
Total
B	B2	B21
Total
B	B3	B31
B	B3	B32
Total
Total
Total

In the above example, i am hiding the first two columns as per my requirement by using a simple VB Script, after hiding I wanted to show the sub totals with the names not as 'total' like ... after A12 instead of Tatal i need to show A1, then after A23 i want to show A2 and so on. Please help me to achieve this. I am new to qlikview.

Thank you all for your help in advance.

[RedSky001]

Settings > User Preferences > Objects  > Change "Default Label for Total"

Is this what you were looking for?

[#3]

Nope, With that we can only change the Default total name to any other name

like Total to Sum or something else. But in my requirement, i want to print that field data name.

for example

Country                State                  City

Americas              New Jersey        Alpha

                                                    Alpine

                                                    Sum(New Jersey)

                            Sum(Americas)

Need to print the field data name instead of default Total.

Hope you understand my requirement now.

Thank you all in advance

[RedSky001]

Create a pivot table object > Presentation.

You'll see a box with each dimension listed.  Click on each one and change the "Label forTotal" accordingly.

i.e. select dimension Country and enter  "Country" also tick "show partial sums"

Mark

[#5]

Hi Mark,

Thank you for the reply, if I do so it will be like "country" but i need that to be as a field ' data' not like field name. like

India total , USA total, UK Total likle this ... the data would be represented ... can anyone or you please help if i can pass a parameter to that 'total' label ???

Thank you all in advance ...

[jagan]

Hi,

It is not possible to change the Total label text based on the dimension value.  I tried a lot earlier for doing this.  There is no such option.

Regards,

Jagan.

[RedSky001]

I don't know a way of doing that rkonatham.

Could an alternative be to do this as an expression?

Something like this:

=MaxString(Country) & ' ' & sum(TOTAL <Country> )

Mark

[#8 · Accepted solution]

Thank you very much to all of you ...

the solution is .. apply a intend mode to the first dimension and second dimenstion...

Properties-->Style-->Indent Mode-->Use Only first Dimension Label

and then apply a bold to the text by dragging the fields...

Properties -->Dimension --->select the dimension in used dimension and expand it-- under that select Text Format ---Edit --- '<b>' ---- apply .. apply it for all the dimensions where you want the text to be in bold...

Thank you all

[RedSky001]

Ramakanth glad to see you worked it out and usefull for other people to know too.

Mark

[#10]

The only good workaround as we are not able to find exact solution for the requirement. Thank You Ramakanth.