Sphinx IQ

Regroup/ Order

It is possible to reorganize a table by regrouping and/or deleting some modalities, and/or by being limited to a number of lines of the table. To perform these actions :

  • Select the analysis on which to apply the regrouping / scheduling.
  • Open the properties of the object in the banner, click on the tab Format, then on the button Properties then click on the tab Calculate.
  • Tick the option Regroup / Sort modalities, then click on the button points
  • Case of one-way table : Select one or several modalities and tick one of the options to apply : Group as, or Do not group, or Ignore. The tab Order allows to rise / descend a modality and to change therefore the order of presentation of the modalities in the analysis.
    regrouper  ordonner 
  • Case of cross / multiple / compound / average table: Write the formulas corresponding to the regroupings and schedulings to apply.

    Regroup the modalities

    The name of the group of the modalities followed by the sign "equal", then the name of modalities to group, between quotation marks and separated by the sign "equal"
    Alcoholic drinks = "Wines" = "Beer" = "Spirits" = "Premixture"

    Delete the modalities

    The name of modalities to delete between quotation marks, separated by a semicolon, all between parentheses
    ("Eau du robinet" ; "Premixture" ; "Wine")

    Limit to number of lines

    The number of lines in the beginning and this at the end, separated by a dash
    1-10

  • Click OK to validate.

 

Retour vers : Reorganize a table