range analysis

[Carlaf_93]

Good morning,

i have those fields:

i would like to associate a single client to the right class.

For example: client gal's value is 30 and it's between limit1 and limit2 so it is in classa.

i would like a table with class, clients,limit1 '-' limit2 as range

Thanks

[MayilVahanan · Accepted solution]

HI @Carlaf_93 

Try with intervalmatch concept. 

Sample:

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

Hope it helps