Pie chart values and percentages

[nareshthavidishetty]

HI All ,

I'm trying to achieve values and percentages on pie chart but unable to get it below is my expression written on Dim

=Product Code]&':'& aggr(num(sum(sum({<DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY]))/
sum(total{<[Product Code]>} sum({<DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY])),'#,##0.00%'),[Product Code])

please help me 

[vikasmahajan]

try this

 =[Product Code]&':'& num( sum({<DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY]) /
sum(Total {<DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY]),'#,##0.00%')

[pradosh_thakur · Accepted solution]

=Product Code]&':'& aggr(num(sum({<DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY])/
sum(total{<[Product Code],DealMaturedDate={">=$(=(vMnthStart))<=$(=(vMnthEnd))"}>}[Outstanding Balance LCY]),'#,##0.00%'),[Product Code])

Try the above. You have used sum(sum())  which is not allowed as we can't use aggregation function on top of another aggreagation function without using aggr() 

[nareshthavidishetty]

Not working 

[nareshthavidishetty]

HI pradosh

its working finally thanks

[pradosh_thakur · Accepted solution]

Great. Please close the thread. Thanks

-Pradosh

[OmarBenSalem]

Hope u'll take well my remark:

Please, before asking a question in the community, take a few seconds to search for ur response in GOOGLE.

See: 

Open the first link :

https://community.qlik.com/t5/New-to-Qlik-Sense/Display-Value-and-Percentage-in-Pie-Chart/td-p/49519

Have a nice day