How to evaluate the value of a field in my expression

[#1]

Hi,

I have an inline table like this:

FMSTextSintesi:

Load * Inline

[FMSDim,FMSVal

PB Attivi, count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

];

What I'm trying to do on the designer is create a linear table with the field "FMSDim" as dimension and for expression I'd like to put the "FMSVal" value.

Obviously this way give me as result of the expression a text. The text in the field "FMSVal" ( count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB) ).

Is it possible to evaluate the value of the field in my expression so I have the result I'm expecting to have??

Thanks in advance

Giampiero

[#2]

It's always the same result and this is wrong

[#3]

Hi Kuldeep Tak and Gysbert.

i want to thank you for your help.

Thanks to your advices I found a way to solve my problem.

Now, I don't use a INLINE table but an excel file.

And, thanks to the thread linked, I found an expression that can help me.

At the moment, the expression works with the value picked from the excel file.

So I'm in a good position to reach my goal.

The last problem I have to solve is the order of the value of my expression.

They're wrong and I can't understand why.

I tried to change that order but nothing changed.

Could you please try to help me?

I attach a file to understand my problem.

Thanks in advanced for your help

Best regard

Giampiero

[Gysbert_Wassenaar · Accepted solution]

You can specify a field to use for the sort order in the concat function. Try:

pick(

Idval,

$(=concat(FMSValue,',',Idval))

)

[#5]

Hi Gysbert,

NOW it's perfect.

I didn't think about it.

Thank you so much.

Just a last question Gysbert.

Do you know if pick() has a limit of character for the string ?

I mean, as you can see from my excel file I have 6 records on my table at the moment.

If I put a new record so I reach 7, the first one FMSDimen disappear and the table starts with the second one.

I have ever 6 records maximum.

It's quite strange.

You could try to insert a new record with Idval = 7 to understand what I'm trying to explein to you (I know my english is not so good so I'm not sure you understand what I'm saying)

Anyway THANK THANK YOU SO MUCH

Best regards

Giampiero

[Gysbert_Wassenaar]

I don't think the pick function has a problem with the length of the expressions. Read this post for example. I didn't have a problem with adding another expression. But it needs to return a non-zero value if the chart properties Suppress Zero-Values and Suppress Missing are enabled (on the Presentation tab). See attached example.

[#7]

I see.

I have to test if I have zero-values as result.

Gysbert again, THANK YOU SO MUCH.

I really appreciated your help.

Best regards

Giampiero