Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How can I create grand total % in Pivot Table as red column?

How can I create grand total % as red column?

1 Solution

Accepted Solutions
prma7799
Master III
Master III

7 Replies
prma7799
Master III
Master III

(Sum(GrandTotal) / Sum(Total GrandTotal)) *100

or

Num(((Sum(GrandTotal) / Sum(Total GrandTotal)) *100), '##0')

panwipa2528
Contributor III
Contributor III
Author

But Grand total I make from > Presentation> Show Partial Sum

prma7799
Master III
Master III

Or write above expression then go to >> Number >> and tick show in Percentage (%)

prma7799
Master III
Master III

In your application showing two Grand Total What is that?

Please share some sample app.

panwipa2528
Contributor III
Contributor III
Author

FYI

PrashantSangle

Hi,

Modify your expression like

if(secondaryDimensionality()=0,count(id)/count(Total id)*100,count(id))

or

if(secondaryDimensionality()=0,num(count(id)/count(Total id),'0.0%'),count(id))

To highlight with red color,

Expand that expression- > Background Color write below expression.

if(secondaryDimensionality()=0,Red())


Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
prma7799
Master III
Master III

PFA..