Displaying the Percentage of Values from the total of Value based on section of range

[#1]

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

[antoniotiman · Accepted solution]

Hi,

see attachment.

Regards,

Antonio

[jagan]

Hi,

Attach some sample file.

Regards,

Jagan.

[#4]

Attached the Sample File in the Main Post.

Thnaks

[#5]

Hi Antonio,

Thanks for the quick answer.

i will check if i can use the same function for a stacked bar chart.

[jagan]

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.

[qlikviewwizard]

Hi Jagan, Where can I find Dimension Limits option?

[jagan]

Hi,

It is in Chart Properties > Dimension Limits

Regards,

Jagan.

[qlikmsg4u]

[qlikviewwizard]

Thank you Jagan and KN.