topic Hi, in QlikView

Hi,

Fri, 01 Aug 2014 09:55:29 GMT

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

Re: Hi,

Fri, 01 Aug 2014 10:13:47 GMT

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

Re: Hi,

sujeetsingh — Fri, 01 Aug 2014 10:25:06 GMT

Seems a new thing do want its cambinations

Re: Hi,

MarcoWedel — Fri, 01 Aug 2014 11:56:33 GMT

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

thanks

regards

Marco

Re: Hi,

Sun, 03 Aug 2014 13:14:40 GMT

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

Re: Hi,

Sun, 03 Aug 2014 13:21:21 GMT

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

Re: Hi,

Mon, 04 Aug 2014 14:41:41 GMT

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