Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Get a value from 2 columns

Bonjour,

I would like to bind an expression to a range of values,

Ex:

Si j'ai une Note entre 0 et 3 je dois afficher "Normale"

EchelleNoteNote
Normale 03
Bien37
Très bien911

les deux tables ne sont pas liées dans le script

Note
5
10

Si j'avais une seule note

Je peux faire:

=FieldValue('Echelle', FieldIndex('Note', 5))

Mais avec un intervalle je ne sais pas comment je peux le faire!

D'avance, merci de votre aide

2 Replies

Re: Get a value from 2 columns

You can use the intervalmatch function to match a value with an interval. See this blog post for more information: IntervalMatch


talk is cheap, supply exceeds demand
Not applicable

Re: Get a value from 2 columns

Thank you for your answer, but the field 'Note' seems to be a graphical expression (which is dynamically calculated). Therefore I can't use that solution...

Thank you in advance for any help in these regards.

Community Browser