topic Re: Pivot table sub totals help needed in QlikView

Pivot table sub totals help needed

Wed, 30 May 2012 14:19:19 GMT

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.

Pivot table sub totals help needed

RedSky001 — Wed, 30 May 2012 14:25:34 GMT

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

Is this what you were looking for?

Re: Pivot table sub totals help needed

Wed, 30 May 2012 14:54:38 GMT

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

Re: Pivot table sub totals help needed

RedSky001 — Wed, 30 May 2012 15:14:40 GMT

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

Re: Pivot table sub totals help needed

Thu, 31 May 2012 12:24:19 GMT

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 ...

Pivot table sub totals help needed

jagan — Thu, 31 May 2012 12:37:01 GMT

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.

Pivot table sub totals help needed

RedSky001 — Thu, 31 May 2012 13:50:06 GMT

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

Re: Pivot table sub totals help needed

Tue, 05 Jun 2012 07:06:52 GMT

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

Re: Pivot table sub totals help needed

RedSky001 — Wed, 06 Jun 2012 09:07:14 GMT

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

Mark

Re: Pivot table sub totals help needed

Mon, 28 Dec 2015 10:40:15 GMT

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