Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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 jaganqliklearnScripting  App Developmentseebachstephen-x.redmondtresescomassimo.morellimiguel.angel

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

see attachment.

Regards,

Antonio

View solution in original post

13 Replies
antoniotiman
Master III
Master III

Hi,

see attachment.

Regards,

Antonio

jagan
Luminary Alumni
Luminary Alumni

Hi,

Attach some sample file.

Regards,

Jagan.

Not applicable
Author

Attached the Sample File in the Main Post.

Thnaks

Not applicable
Author

Hi Antonio,

Thanks for the quick answer.

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

jagan
Luminary Alumni
Luminary Alumni

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
Master II
Master II

Hi Jagan, Where can I find Dimension Limits option?

jagan
Luminary Alumni
Luminary Alumni

Hi,

It is in Chart Properties > Dimension Limits

Regards,

Jagan.

qlikmsg4u
Specialist
Specialist

Capture.PNG

qlikviewwizard
Master II
Master II

Thank you Jagan and KN.