Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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

Labels (1)
36 Replies
Not applicable
Author

I will try tomorrow.

sunny_talwar
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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

Best,

S

sunny_talwar
MVP
MVP

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

Best,

S