If with 4 conditions

[NK]

Hello, 

I want to show marks （◎, 〇, △, ×）according to the condition below.

Index >1.1　→ ◎

Index >1.0　→ 〇

Index >0.9　→ △

else　→ ×

Does anyone know how to set the formula for this?

(may be like: If (Index =>1.1 '◎', =>1.0 '〇', 0.9=> '△', ×)?)

Thank you.

[petter]

This should work for you - I tested it quickly and it works for me:

Pick( Match( Index , 1.1 ,  1.0 , 0.9 ) + 1 , '×' ,'◎', '〇', '△', '×')

[petter]

... sorry my suggestion had an extra 'x' at the end that is not needed.

This should be sufficient:

Pick( Match( Index , 1.1 ,  1.0 , 0.9 ) + 1 , '×' ,'◎', '〇', '△')

[UserID2626 · Accepted solution]

If (index>=1.1 ,Chr(9678),
If (index>=1.0 and index<1.1 ,'〇',
If (index>=0.9 and index<1.0,Chr(9651),
chr(9685))
)
)

https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Conditional-Performance-Indicators-in-Tabl...

https://www.w3schools.com/charsets/ref_utf_geometric.asp

[NK]

Thank you!

But it doesn't show any results...↓

The value of index look like this↓

So maybe there should be "> "?

 

[NK]

Thank you very much!

It worked.

I didn't know about this Character code !

[UserID2626]

Pick(Match(-1, INdex >=1.1
, INdex >=1.0 and INdex <1.1,
INdex >=0.9 and INdex <1.0), Chr(9678),'〇',Chr(9651),'x')