Return pick match condiotional

[jsobrinho]

Hi guys,

I need to verify if each line in my pick match is zero it is zero I need to put N/A, else the value. There is another way to getting the return of pick match and set the N/A to zero values? or is better do this for each line, with if statement inside pick match?

[rubenmarin]

Hi, adding one to match can help?:
Pick(Match(...)+1
, 'N/A'
, Expression for Match=1
, Expression for Match=2
...)

[jsobrinho]

First of all, thank you for your answer..

I'm doing this
Pick(Match(...),
if (Expression for Match=1 is zero, 'N/A',
Expression for Match=1),
if(Expression for Match=2 is zero, 'N/A', Expression for Match=2

...)

I dont know if +1 is solve my problem

[rubenmarin]

Have you tried? it works

[jsobrinho]

I want to eliminate the if, inside the pick match, I would like to optimize my pick match

[rubenmarin]

There is no if in my answer.

[jsobrinho]

The + 1 is used when one of these combinations doesn't occur Pick(Match(...),
like Pick (match(country,'A','B','C') + 1,
99
In this example, if Country is different from A, B, C will be shown the 99
But my problem is
after this match
Pick (match(Country,'A','B','C')
I need to do other comparations like
Pick (match(Country,'A','B','C'),
if(
sum({<Country={'A'}, LEVEL={'X'}>}sales) >0,
sum({<Country={'A'}, LEVEL={'X'}>}sales) ,'N/A')
.....
I have a lot of option of Country, and I need to verify if this option is zeros or not, with IF inside pick match, exist another way or better to simply this logic for better performance?

[rubenmarin]

Ok, now I understand, but i don't know otyher way to do that.

Maybe using RangeMax(0, [Expression]) and check the option to supress zero value can work if your table only has one measure.

There is also the alt() function to control no-numeric results but I think it can't work in this case.

[jonathandienst]

I think if you supply the full expression you have, then that will eliminate some guesswork on the part of those trying to help you. Better still, put together and upload a small qvw file with some representative  data (does not need to be real numbers, but the structure should be the same), including the sheet object where you need the expression and details on what output values you want.

[jsobrinho]

OK, I'm sorry
I attached one example.