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

[#2]

How to can i use slider if i uncheck dimenesions limits.

Can you please tell be best to way to over come this. Thanks

[jagan]

We are controlling this in the set analysis expression using the variable assigned to the slider.  This will do the job for you.

=If(Rank(sum(spend)) <=Vtop, Sum(spend)) / Sum(TOTAL spend)

Hope this helps you.

Regards,

jagan.

[#4]

Hey Jagan,

I just used the approach you specified but i could't able get the solution.

Can you please share that in the sample QVW please.

Thanks.

[jagan]

PFA.

Regards,

Jagan.