Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide details show only total?

Hi is there a way to do this on a Pivot Chart Table?

1.JPG.jpg

Thanks in advance

1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

hi you can use the following expression

if(ColumnNo()>0 and rowno()>0,'','Total Exp') and

go to >> user preferences>>designtab>>enable check box "always shown design menu items">>ok

then right click on chart >>choose custom format cell for rows

find attachment

View solution in original post

7 Replies
preminqlik
Specialist II
Specialist II

hi you can use the following expression

if(ColumnNo()>0 and rowno()>0,'','Total Exp') and

go to >> user preferences>>designtab>>enable check box "always shown design menu items">>ok

then right click on chart >>choose custom format cell for rows

find attachment

SergeyMak
Partner - Specialist II
Partner - Specialist II

My solution is like a photoshop job, but probably it could help you.

I just created two tables and moved Total to the begining.

PFA sample

Regards,
Sergey
Not applicable
Author

How about using the Year_v partial sum, can we also manipulate it's value?

1.JPG.jpg

SergeyMak
Partner - Specialist II
Partner - Specialist II

I don't think that you can manipulate it separtly

Regards,
Sergey
Not applicable
Author

Thank you for the help guy's it was really helpful on my end.

Not applicable
Author

How do we hide the highlighted labels and shows only the label on the partial sum part?

1.JPG.jpg

SergeyMak
Partner - Specialist II
Partner - Specialist II

You can use custom format cell

You should enable Design Grid

Then Right Click on the marked by you column names and select from the menu "custom format cell"

Then change the transparency for Text Color 100%

Regards,
Sergey