Set Analysis Text Table Chart

[#1]

Hi,

currently i facing following problem:

I have a table chart where Text should be displayed but different from the current selection. Thats why I thaught this works with using Set Analysis.

The problem is that i do not have any clue which funciton I can use for Text. Sum of course gives me always NULL.

I also tried with Text() but there i can not use set analysis.

Remarks.ShortDescription is text.

regards,

corleone

sum( {$<Remarks.Date=, Remarks.State={*}-{'closed'}>} Remarks.ShortDescription)

[IAMDV · Accepted solution]

Hi Corleone,

Have you tried use Only() Function?

Only( {$<Remarks.Date=, Remarks.State={*}-{'closed'}>} Remarks.ShortDescription)

Because, we don't want to perform aggregation on the field. If this doesn't work, then please can you post the sample QV document and I can work on the expression.

Cheers - DV

[gandalfgray]

Try any of these:

MinString( expression )

MaxString(expression )

FirstValue(expression)

LastValue(expression)

hth/gg

[#4]

Thanks DV for the fast support! perfect!

[IAMDV]

Corleone - You are welcome. I am glad it worked for you.

Cheers - DV