Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
crissaegrim
Not applicable

Greater than or equal to in pick match

I've got an if statement like this...

    if(fabs(duration) >= 10, 10,

         if(fabs(duration) >= 9, 9,

              if(fabs(duration) >= 8, 8,

                   ...

                   )))

Can I turn it into a `pick(match())` statement?  How?

    

1 Solution

Accepted Solutions
maxgro
Not applicable

Re: Greater than or equal to in pick match

maybe

=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)

1 Reply
maxgro
Not applicable

Re: Greater than or equal to in pick match

maybe

=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)