Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
dberkesacn
Partner - Creator III
Partner - Creator III

pick match

Hi Community,

how can I create a pick / match combination which would give me 3 alternative.

pick(match(???,???),'-0.8',FACT.VALUE,'0.8')

"VALUE >=0.8"  should give 0.8

"0.8 > VALUE >  -0.8"  should give the VALUE

"VALUE <= -0.8" should give -0.8

Best,

Dan

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

That's not what pick-match is for. You can use this instead:  RangeMin(RangeMax(-0.8,FACT.VALUE),0.8)

But if you insist you can try Pick(1 + Match(-1, (FACT.VALUE < -0.8), (FACT.VALUE > 0.8)), FACT.VALUE, -0.8, 0.8)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

That's not what pick-match is for. You can use this instead:  RangeMin(RangeMax(-0.8,FACT.VALUE),0.8)

But if you insist you can try Pick(1 + Match(-1, (FACT.VALUE < -0.8), (FACT.VALUE > 0.8)), FACT.VALUE, -0.8, 0.8)


talk is cheap, supply exceeds demand