Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Caluclation

Hi Every one,

I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.

Make sure that this change should not reflect to other selections.

Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))

Thanks for your help in advance.

Raj

36 Replies
Not applicable
Author

I will try tomorrow.

sunny_talwar

Not a problem.

Best,

S

Not applicable
Author

Thanks Sunindia,

finally I got it, really thank you very much. On first incident itself, you found the solution but from my side made some mistake.

Thank you.

sunny_talwar

I am glad that finally we were able to get to the solution.

Best,

S

Not applicable
Author

Hi Sunindia,

Please try to answer for the below thread as its same kind of issue.

http://community.qlik.com/message/708790#708790

Thank you

sunny_talwar

I will look at it in a bit. Thanks for reaching out.

Best,

S

sunny_talwar

I just answered your question. Hope it will be helpful.

Best,

S