Set analysis in Text Object for string

[#1]

Hello,

I would like to know if it is possible to use a set analysis restriction in a text object but without any expression.

In another words: usually the set analysis is made with a expression like: count, max, aggr, sum, etc and the respective restrictions.

I want to use a set analysis without the expression because I want to show a string and not a value, but I need the restrictions that a set analysis provides me.

Any thoughts?

Thank you.

Best regards.

Ivo Marques

[MK_QSL]

You can use.... FirstSortedValue in combination of Aggr and Set Analysis to achieve this..

Provide sample data.

[Anonymous]

you may use max or only in combination with your string

[#4]

I have the following:

=max({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description)

And the value 'Description' is a string.

This comes from a sql query and has many different strings, but with the restrictions I have the is only one string that should appear on the text object.

[MK_QSL]

=maxstring({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description)

[#6]

This returns in fact the max string but without obeying the the restrictions.

Just the max string of the entire universe of 'Description'

[MK_QSL · Accepted solution]

=Concat({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description,', ')

[Anonymous]

Maxstring() works with set analysis.  Something's wrong with your set.

[#9]

Yes it is.

My bad, I caught the problem with my set, but now I don't know how to fix it.

In the set can I use mid(KNR,3,1)={'7'}?

=maxstring({<TestArea={'ASD'},mid(KNR,3,1)={'7'},Description-={'Not valid values:'},Results-={'0'}>} Description)

[Anonymous]

No, you can't.  It is always a field on the left side.  Maybe something like

Field = {" =mid(KNR,3,1)='7' "}

or even remove it from set:

=maxstring({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} if(mid(KNR,3,1)=7, Description))