Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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!

Highlighted
MVP & Luminary
MVP & Luminary

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".
Highlighted
Not applicable

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

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

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

Highlighted
Not applicable

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