topic Re: Classify values. in QlikView

Classify values.

spividori — Thu, 13 Sep 2012 21:23:14 GMT

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.

Re: Classify values.

jvitantonio — Fri, 14 Sep 2012 08:18:58 GMT

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.

Re: Classify values.

Fri, 14 Sep 2012 08:49:03 GMT

Hi,

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

regards

Re: Classify values.

jvitantonio — Fri, 14 Sep 2012 08:52:08 GMT

Krunoslav, thank you. You solution would be simpler.

Re: Classify values.

spividori — Fri, 14 Sep 2012 11:51:23 GMT

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.

Re: Classify values.

jvitantonio — Fri, 14 Sep 2012 12:15:46 GMT

The you have to do it by hand using IF

Re: Classify values.

Anonymous — Fri, 14 Sep 2012 19:12:18 GMT

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;

Re: Classify values.

spividori — Fri, 14 Sep 2012 20:11:04 GMT

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.