Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Re: Re: Re: How to calculate % in the table of chart properties.

Hi,

One of the work around could be like this.

Regards

ASHFAQ

23 Replies
ravic906
Not applicable

Re: How to calculate % in the table of chart properties.

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

Re: How to calculate % in the table of chart properties.

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

ravic906
Not applicable

Re: How to calculate % in the table of chart properties.

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

Re: How to calculate % in the table of chart properties.

Please use this expression:

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

ashfaq_haseeb
Not applicable

Re: How to calculate % in the table of chart properties.

Hi May be like this

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

Or use Relative on expression.

Regards

ASHFAQ

Not applicable

Re: How to calculate % in the table of chart properties.

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

Re: How to calculate % in the table of chart properties.

Hi nishika,

please find attached QVW with solution

regards

harshal sonone

satishkurra
Not applicable

Re: How to calculate % in the table of chart properties.

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

Re: How to calculate % in the table of chart properties.

Hi Harshal,

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