How best to Group data

Thu, 10 May 2012 11:48:37 GMT

Hi all,

Can anyone tell me how I go about grouping data in a table. I have tried the grou by but this doesnt seem to work. Attached is a sample to show what I need.

The reason I need this is I need to use a bubble chart to visualise client pipeline and liklyhood of winning client (pipeline report) At the moment I am showing connected bubbles as the graph treats each line separately so need to combine.

Thanks in advance for any help.

Re: How best to Group data

jagannalla — Fri, 11 May 2012 09:05:38 GMT

Hello,

Use this code:

Temp:
LOAD [field 1],
     [field 2],
     [field 3],
     [field 4],
     [field 5],
     [field 6],
     [field 7],
     [field 8],
     [field 9],
     [field 10],
     [field 11],
     [field 12]
FROM
(biff, embedded labels, table is [Sheet2 (2)$]);
Main:
LOAD [field 1],
MaxString([field 1]) as Temp,
MaxString([field 2]) as [field 2],
MaxString([field 3]) as [field 3],
MaxString([field 4]) as [field 4],
MaxString([field 5]) as [field 5],
MaxString([field 6]) as [field 6],
MaxString([field 7]) as [field 7],
MaxString([field 8]) as [field 8],
MaxString([field 9]) as [field 9],
MaxString([field 10]) as [field 10],
MaxString([field 11]) as [field 11],
MaxString([field 12]) as [field 12]
Resident Temp
Group By [field 1]
;
DROP Table Temp;

- check sample file if you required.

topic How best to Group data in QlikView

How best to Group data

Re: How best to Group data