Set analysis for non number data

[#1]

Hi everyone,

I am wonder if there if there is any thing similar to set anaylsis for non-numerical data. E.g. In the data base, which company name (selection list box) link with some notes. And I allow user to select one extra company for data comparsion. For number, I can use set analysis (e.g. sum({$<company = Second_Selection>}Size), etc). But how can I do that for the notes?

To get notes for the "Main" company, the formula is simply "=Notes". How can I show the notes of another company??

Regards,

Ivan

[#2]

Hi Ivan

If you look up the set examples in book III page 355 ff you can see many examples using set for non-numeric fields, e.g.

sum({$-1<Product = {"*Internal*","*Domestic*"}>} Sales)

This will give you the result of the current selection minus the Internal and Domestic Products

Juerg

[#3]

Hi Juerg,

Thanks for your advise. However, all examples use "sum", including your example. Sales are number, therefore, it makes no problem by using "sum" function.

But " notes" are text, same for its content. Therefore, I can use "sum" with set anaylsis.

Regards,

Ivan

[#4 · Accepted solution]

Hi

You want to concat notes then based on the selections?

like

concat('Notes')
or
aggr(concat('Notes'), <group>)

[#5]

Hi,

Thanks for the suggestion. It works by using concat({Set} distinct Notes)