Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

Combination of Values

Hi  Team,

I have requirement like below 

1 one
2 two
3 three
4 four
5 five
update
No update

I need to create one filter like 

If -1 one,2 two,3 three---10+

if - 2 two,3 three-20+

If -3 three, 4 four, 5 five-30+

 

Please let me know how I can write expression and I am trying like below expression. But its not giving 20+

if(Match(filed,'1 one','2 two','3 three') ,'10+',
if( Match(filed,'2 two','3 three'),'20+'))

 

Regards,

Siva

 

 

 

 

Labels (1)
0 Replies