topic Re: Value adding to other Periods in QlikView

Value adding to other Periods

priyarane — Wed, 11 Feb 2015 15:35:36 GMT

Hi Every one,

Currently below expression I am using.

(Trad_PRODUCT_TYPE = 'OTC Derivative',
aggr(sum(TOTAL<Trad_CRISP_PARENT_FULLNAME,Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD> Trad_UNREALIZED_PL),Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD),
if(Trad_PRODUCT_TYPE = 'SFT',
aggr(sum(TOTAL<Trad_CRISP_PARENT_FULLNAME,Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD> Trad_COLLATERAL_VALUE),Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD),
aggr(sum(TOTAL<Trad_CRISP_PARENT_FULLNAME,Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD> Trad_CURR_BOOK_VALUE),Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD)))

And my issue is P0 values, I need to add it to other periods. Refer screen shot.

ex:

P0 P1 P2 P3

10 5 3 25

Output should be

P0 + 0 P1+P0 P2+P0 P3+P0

10 15 13 35

Thank you,

Priya

Re: Value adding to other Periods

giakoum — Wed, 11 Feb 2015 15:39:57 GMT

the same (terrible...) expression needs to be added but only for P0. You can use set analysis for that :

aggr(sum({<[Period]={"P0"}>} total .........etc

Re: Value adding to other Periods

priyarane — Wed, 11 Feb 2015 15:58:12 GMT

Hi Ioannis,

You mean to say,

(Trad_PERIOD='P0',0,aggr(sum(TOTAL<Trad_CRISP_PARENT_FULLNAME,Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD>{<Trad_PERIOD={'P0'}>} Trad_UNREALIZED_PL),Trad_PARENT, Trad_CLOSEOUT_AGREEMENT_NUMBER,Trad_PERIOD))

Re: Value adding to other Periods

giakoum — Wed, 11 Feb 2015 16:10:45 GMT

yes you can do it with if also, but then your expression gets really complicated

Re: Value adding to other Periods

priyarane — Wed, 11 Feb 2015 18:32:17 GMT

Hi Ioannis,

my if statement not worked out.

Could you please elaborate your expression if possible?

Thank you,