topic Re: Easy classification in QlikView

Easy classification

Thu, 05 Dec 2013 11:16:31 GMT

Hello,

i have a questions regarding to a classification in QlikView.

Now this is my table:

Client; Client_distances; Kennzahl

A; A; 0

A; B; 10

A; C; 25

B; A; 10

B; B; 0

B; C; 45

C; A; 25

C; B; 45

C; C; 0

QlikView should classify the attribute Client_Distances (A, B, C) according to following rules:

IF(Kennzahl <= 25) then Client_distances into Cluster 1

ELSE(Kennzahl > 25 & <= 50) then Client_distances into Cluster 2

….

The result of the classification must be visualized in a graph where you can see which Client_DIstances is in a specified cluster like 1, 2 or 3 …

Is it possible to build something in QlikView?

Thanks and regards,

Thomas

Anonymous — Thu, 05 Dec 2013 11:21:55 GMT

Hi Thomas,

You can add a calculated dimension:

IF(Kennzahl <= 25,'Cluster 1',

if(Kennzahl > 25 and Kennzahl<= 50,'Cluster 2',

'Cluster 3'))

Now you can easily classify in the chart according to Cluster 1,2,3 .....

Regards

Nitin

Thu, 05 Dec 2013 11:29:32 GMT

Hi Thomas,

PFA one of the possible ways to achieve this.

Hope this helps!