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

How to calculate % in the table of chart properties.

I am trying to calculate the percentage ,i am not able to sum the values of the Grand total because it is the expression in the chart option.The expression for grand total is: count({<CategoryDefect={'Application','User Training','Environment','App Config','Scope Change','Duplicate'}>}CategoryDefect).The Grand Total value is not static value it will change according to the selection of product line.

I have uploaded the excel sheet of the table that i want to be displayed  .

Thanks.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

One of the work around could be like this.

Regards

ASHFAQ

View solution in original post

23 Replies
Anonymous
Not applicable
Author

Hey,

To get the percentage as another column,do use (Grant Total/Sum(TOTAL Grant Total))*100

but, to get at the bottom of the chart, I think u need to make use of text boxes.

HTH,

Ravi N.

Not applicable
Author

i tried to take (Grant Total/Sum(TOTAL Grant Total))*100  it is showing Blank.No values are coming.

Anonymous
Not applicable
Author

It should work. It worked for me. Nonetheless,use relative option. Just use sum(Grand) as exp and click on relative in the expression tab.

Not applicable
Author

Please use this expression:

(sum(Grant Total)/Sum(TOTAL Grant Total)))*100

ashfaq_haseeb
Champion III
Champion III

Hi May be like this

(sum(Grant Total)/Sum(TOTAL Grant Total)))*100

Or use Relative on expression.

Regards

ASHFAQ

Not applicable
Author

Hi Nishika,

I tried your problem and i found the following solution that i tried in text box. it is as follows

=Num(Sum(TOTAL Application)

/

(Sum(TOTAL Application)+ Sum(TOTAL User Training)+ Sum(TOTAL Environment)+Sum(TOTAL APP Config)+Sum(TOTAL Scope change)+Sum(TOTAL Duplicate)),'#.#%')

you will get the 46.94% for ''2521/5370"

check it out.



Not applicable
Author

Hi nishika,

please find attached QVW with solution

regards

harshal sonone

satishkurra
Specialist II
Specialist II

Hi

In chart properties for Number Tab against the expression set the number format to 2 decimal and check show in Percent option

Thanks

Satish

Not applicable
Author

Hi Harshal,

  I am not able to do it it is showing error in the statement ,I have attached the qvw file please check .