Solved: Re: particular cell summation - Page 2 - Qlik Community

srujanaponnuru · ‎2015-07-15

Hi,

The below data is shown as:

I want a pivot table to calculate the sum of stress test values only for equity type , derivatives etc separately.

example: for equity I want the summation of position 1 + position 2 + Positiion 3 (I,e = (-699+(-118)+-(-972))

Please help me out.

REgards

Srujana

qlikmsg4u · ‎2015-07-15

Is this you want...please tell us the requires output

alex_millan · ‎2015-07-15

Hi again,

If you can switch the order of some of the columns, you can set the dimensions on the left and the calculations on the right:

As Dimensions:

- Portfolio

- [Asset class]

- Position

As expressions.

Sum x portfolio = Sum(TOTAL <Portfolio> [Stress Test Values])

Sum x asset class = Sum(TOTAL <[Asset class]>[Stress Test Values])

Sum x position = Sum([Stress Test Values])

HTH

Regards,

srujanaponnuru · ‎2015-07-15

Hi,

I should get fields in a pivot table as Asset class, Position thru these two fields I need to calculate Column L from Column N.

antoniotiman · ‎2015-07-15

Hi this is what You want ?

See Attachment

Regards

srujanaponnuru · ‎2015-07-15

Yes, but I have so many positions and Asset classes, I cant mention all the positions in that expression. Is there any other way to do it ?

any way thank you for your help.

regards

Srujana

Kushal_Chawda · ‎2015-07-15

Please see the attached.

This is what you are looking for

antoniotiman · ‎2015-07-15

Change expression to

Sum({<[Asset Class]={'Equity'}>} [Stress Test Values3])

srujanaponnuru · ‎2015-07-15

Hi Kush,

thanks a lot for your help. It worked.

Regards

Srujana

Kushal_Chawda · ‎2015-07-15

srujanaponnuru‌ have you seen the application which I have attached