Hi,

[#1]

please help me for showing cluster in Qlikview. As i have loaded two sheets. one sheet shows Ratings (s) and another shows Grades(k) so from these i have to make cluster as bellow-

k1s1,k1s2,k1s3,k1s4

k2s1,k2s2,k2s3,k2s4

k3s1,k3s2,k3s3,k3s4

k4s1,k4s2,k4s3,k4s4

please help me to build this cluster

[#2]

In the load script:

Load

if((k= k1 and s=s1) or (k=k1 and s=s2) or (k=k1 and s=s3) or (k=k1 and s=s4),'Cluster1',

if((k= k2 and s=s1) or (k=k2 and s=s2) or (k=k2 and s=s3) or (k=k2 and s=s4),'Cluster2',

if((k= k3 and s=s1) or (k=k3 and s=s2) or (k=k3 and s=s3) or (k=k3 and s=s4),'Cluster3',

if((k= k4 and s=s1) or (k=k4 and s=s2) or (k=k4 and s=s3) or (k=k4 and s=s4),'Cluster4')))) as Cluster

[sujeetsingh]

Seems a new thing do want its cambinations

'

[MarcoWedel]

Can you please explain a bit more, maybe with a sample table?

thanks

regards

Marco

[#5]

hi Mario,i have tried this one  but its not working ...

[#6]

yes, i want this combination and these values are from two different sheets

k1s1,k1s2,k1s3,k1s4

k2s1,k2s2,k2s3,k2s4

k3s1,k3s2,k3s3,k3s4

k4s1,k4s2,k4s3,k4s4

[#7]

Try to add the apex and check the combination...

Load

if((k= 'k1' and s='s1') or (k='k1' and s='s2') or (k='k1' and s='s3') or (k='k1' and s='s4'),'Cluster1',

if((k= 'k2' and s='s1') or (k='k2' and s='s2') or (k='k2' and s='s3') or (k='k2' and s='s4'),'Cluster2',

if((k= 'k3' and s='s1') or (k='k3' and s='s2') or (k='k3' and s='s3') or (k='k3' and s='s4'),'Cluster3',

if((k= 'k4' and s='s1') or (k='k4' and s='s2') or (k='k4' and s='s3') or (k='k4' and s='s4'),'Cluster4')))) as Cluster