Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 7

CLUSTER# returns a document or TeLiTab set with clustered data based on a series of solutions

Syntax

  1. CLUSTER#(ObjName$)
  2. CLUSTER#(0, ParList$, CellDelim$, ColArr$, IntSortCol%, IntAllowDoubles%)
  3. CLUSTER#(1, SearchPar or SearchPar$, CaseNos$, [InpVar])

Arguments 

Method 1

  • ObjName$ (a StrExp) is the name of an object and returns a TeLiTab#;

...

  • 1 returns a TeLiTab#
  • SearchPar or SearchPar$ (a StrExp) is either a parameter or "parameter" as string. Please note that using a search parameter without quotes, requires te availability of a DETERMINED value for this parameter in the current solution.
  • CaseNos$ (a StrExp) is a list of cases in the solutions to be retrieved. Use "0" or "NullString" if all available cases should be selected. If you want to have a particular set of cases of a solution, a list of cases should be provided, e.g. "3,4,5,6".
  • [InpVar] (a StrExp) is an optional series of parameters to be included in the TeLiTab set seperated by comma's.

Remarks


  1. CLUSTER# arranges data from a series of solutions selected by means of the Workbase right button menu options:

...

  1. These menu options in combination with the CLUSTER#() function allow you to select a number of solutions in the workbase and to retrieve and use their data in a new solution, e.g. for the automatic preparation of documents or to place a serie of result from solutions into a new solution to present differences etc..
  2. Method 1 and 3 return a telitab, method 2 returns a document (large text without a particular meaning to Quaestor).

...

This method will return a TeLiTab#. The syntax is

CLUSTER#(ObjName$)

in which ObjName$ is the name of the (multi-case) object to be the container of the solutions in the cluster.

...

If the cluster contains only one solution, CLUSTER#(ObjName$) returns a single case TeLiTab# set:

...

This method will return a document:

CLUSTER#(0, "#LWL##LWL#,#B#", ", | and ", "NullString", 0, 1)

Parlist$ is "#LWL##LWL#,#B#". The parameters should be surrounded by # and can be delimited by comma's or spaces. It is also allowed to use # as delimiter but the parameter list should at least be started and closed by #, so "#LWL#B##LWL#B#" is also allowed.

CellDelim$ is ", | and ". The '|' will be the delimiter used for all clustered values except before the last one, e.g. four values will then be presented as "a, b, c and e".

...

This method will return a TeLiTab#:

CLUSTER#(1, A$, "0", B)

SearchPar is A$. Please note that A$ should be a DETERMINED value in the current solution. SearchPar is the key and any set of data from a solution which includes SearchPar is only added to the clustered dataset if the value of SearchPar is not yet present in this clustered dataset.

...

InpVar is B. The parameters should be given either with or without quotes (see also QuaestorSyntax). Please note that if you use the name without quotes the system will require a DETERMINED value of the parameter in the current solution.


Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview