Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Settings > User Preferences > Objects > Change "Default Label for Total"
Is this what you were looking for?
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
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
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 ...
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.
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
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
Ramakanth glad to see you worked it out and usefull for other people to know too.
Mark
The only good workaround as we are not able to find exact solution for the requirement. Thank You Ramakanth.