Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Pivot table sub totals help needed

Hi All,

In my pivot table i have three columns,

Countrystatecity
AA1A11
AA1A12
Total
AA2A21
AA2A22
AA2A23
Total
BB1B11
BB1B12
Total
BB2B21
Total
BB3B31
BB3B32
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.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Pivot table sub totals help needed

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

View solution in original post

9 Replies
Highlighted
Contributor III

Pivot table sub totals help needed

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

Is this what you were looking for?

Highlighted
Not applicable

Re: Pivot table sub totals help needed

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

Highlighted
Contributor III

Re: Pivot table sub totals help needed

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

Highlighted
Not applicable

Re: Pivot table sub totals help needed

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

Highlighted
MVP & Luminary
MVP & Luminary

Pivot table sub totals help needed

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.

Highlighted
Contributor III

Pivot table sub totals help needed

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

Highlighted
Not applicable

Re: Pivot table sub totals help needed

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

View solution in original post

Highlighted
Contributor III

Re: Pivot table sub totals help needed

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

Mark

Highlighted
Not applicable

Re: Pivot table sub totals help needed

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