Percentage Range needed for Total Sales by Office

[MuraliPrasath]

Hi,

I've a data like below I need to create a chart for Percentage Ranges based on Office Sales.

Now I need a simple chart to show which office Total Sales comes under these ranges <25%, 26-50%, 51-75%, 76-100% range chart need to create. Any chart is fine. 

[jmartineze]

Hello, you have two options.

1- use intervalmatch function at script.

2- use class function in chart.

Personally, I prefer to use intervalmatch function.

J.

[Brett_Bleess]

Just wanted to give you the Help links on the suggestions from the other poster:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/IntervalMatch_(...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

Here is a Design Blog post on Intervalmatch that may be helpful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Regards,
Brett