Classify values.

[spividori]

Hi.

In a pivot table I have a field with numeric values​​: "Note".
I need to classify as follows:
If "Note" is between 1 and 3 = 'M', if it is between 4 and 7 = 'B', if it is between 7 and 10 = 'MB' and if greater than 10 = 'E'.
This is an example that could use the clause "if", but I need it for more values​​, so I wanted to know if there is any other simpler way to do it.

Regards.

Sandro.

[jvitantonio]

Hi, in this case it's better to have a table so you can add the values you need dinamically. Please check out the attached application.

I hope this helps.

[#3]

Hi,

the same approach as proposed by qlikuser14, but this time using IntervalMatch for classifying.

regards

[jvitantonio]

Krunoslav, thank you. You solution would be simpler.

[spividori]

HI.

Thanks for responding.
In my board "Note" is a calculated column in pivot table.
I did it this way to make it simpler example. The values ​​of the column "Note" are not 1 to 10, and I have to calculate three types of classifications based on the data in column "Notes".
I hope you understand me.

Regards.

Sandro.

[jvitantonio]

The you have to do it by hand using IF

[Anonymous]

You can make a new table with the range and the classification, then to use intervalmatch.

For example:

Table:

NoteA, NoteB, Classification

1         3         M

4         7         B

8        10        MB

11       x         E

Inner join intervalmatch(Note)

LOAD

NoteA, NoteB

From Table;

[spividori]

Hi Romina,

But "Note" is a calculated column in my pivot table, so I need to do the classification in the pivot table.

Regards.

Sandro.