Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Hide details show only total?

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
Highlighted
Specialist II
Specialist II

Re: Hide details show only total?

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

Highlighted
Partner
Partner

Re: Hide details show only total?

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

Re: Hide details show only total?

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

1.JPG.jpg

Highlighted
Partner
Partner

Re: Hide details show only total?

I don't think that you can manipulate it separtly

Regards,
Sergey
Highlighted
Not applicable

Re: Hide details show only total?

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

Highlighted
Not applicable

Re: Hide details show only total?

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

1.JPG.jpg

Highlighted
Partner
Partner

Re: Re: Hide details show only total?

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