calculate percentages

[srujanaponnuru]

Hi i have the data shown below:

Asset   Class	Stress Test   Values	Scenario
Equity	289	Historical
Equity	473	Hypothetical
Equity	811	Sensitivity
Derivatives	502	Historical
Derivatives	113	Hypothetical
Derivatives	742	Sensitivity
Fixed Income	789	Historical
Fixed Income	636	Hypothetical
Fixed Income	588	Sensitivity
Forex	238	Historical
Forex	816	Hypothetical
Forex	420	Sensitivity
Forex	583	Historical
Commodities	410	Hypothetical
Commodities	799	Sensitivity

I need to create a pie chart showing the stress test values percentages by scenario type.

Please help me out.

Regards

Srujana

[qlikmsg4u]

Please find the attached app..

Before you post anything please try to do some work .

[tresesco]

Dimension : Scenario

Expression : Sum([Stress Test  Values])

Check 'Relative' in the expression tab.

[srujanaponnuru]

Thank you all. It worked. I am very new to Qlikview.

I apologize for asking simple queries.

Regards

Srujana

[qlikmsg4u]

No issues, if you try harder definitely you will get the answers.

Please remember to check Helpful a d Correct answers, so that it will be helpful to others to find correct solutions.

[#6]

Hi,

Hope it will help u

use expression for the calculation of %

=(sum(value)/sum( total value))*100

thanks and regards

Balaji.k

[sasiparupudi1]

Please close this thread by marking the correct answer