Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I been posed with a requirement where the client wants to see the percentage of the values for the selected range to the total Value.
For Example the client the client wants to see the value percentage of top 10 suppliers spend to the total spend.
I defined a slider to define the supplier range whether it is top 10 or 15 or 20 the total need to reflected accrodingly to the selection.
Please help me in finding a solution for this.
Thanks
Surendra Kumar Chunduri
hicdvqlikviewgwassenaar jagan qliklearnScripting App Development seebach stephen-x.redmond tresesco massimo.morelli miguel.angel
Hi,
see attachment.
Regards,
Antonio
Hi,
Attach some sample file.
Regards,
Jagan.
Attached the Sample File in the Main Post.
Thnaks
Hi Antonio,
Thanks for the quick answer.
i will check if i can use the same function for a stacked bar chart.
Hi Surendra,
Uncheck Dimension Limits option, and use below as expression
=If(Rank(sum(spend)) <=Vtop, Sum(spend)) / Sum(TOTAL spend)
Hope this helps you.
Regards,
Jagan.
Hi Jagan, Where can I find Dimension Limits option?
Hi,
It is in Chart Properties > Dimension Limits
Regards,
Jagan.
Thank you Jagan and KN.