Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Pivot Table: Show only the total value

Hi,

Is this possible in qlikview especially in a pivot table:see the image below

i want to hide the values of the column(columns in blue) and show only the total..

6 Replies
Not applicable
Author

Use a formula that evaluates to null if inside an internal cell.

E.g.: let's say your innermost dimension is Field1 and the expression you want to get the total is Sum(Amount).

You could use

=If(Count(Distinct Field1) = 1, Null(), Sum(Amount))

Untested, just to give you an idea.

Good luck!

Hi,

If you just want to hide the values all you can do is change the color of the text.

There are 2 ways u can do that.

Click on + sign next to expression. find the text color. where you can write the code.

or

go to properties-> find the visual cues-> set upper and lower limit and change the colors of that as you want.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

i think if i change the text color of the expression if will affect the whole column.what I want to to is to hide the text of a certain column except its total...

Anonymous
Not applicable
Author

Hey Mars,

One way is to use Dimensionality(). This function gives you an integer value depending on what dimension level you're on. The total row will belong to another level than the detail rows.

Specialist

hi,

you can use the function dimensionality().

This will tell you at what level your cell is in the pivot table structure. So In your example where you have two dimensions the cells you wish to hide will have dimensionality > 1. So you can write your expression like this:

=if(dimensionality()>1,' ',YourExpressionHere)

as the pivot recalculates the expression on total lines the Total will appear whereas the other cells will be blank.

If you have more dimensions you will have to tweak the condition set on dimensionality().

hope this helps.

Not applicable
Author

i'll give this a try..thank you so much sir Johannes

Community Browser