Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead 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

Picture.JPG

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!

kaushiknsolanki

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.

    Hope this will help you.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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...

jsn
Master
Master

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.

Please see attached example file.

pat_agen
Specialist
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