Load distinct on a single column?

Wed, 13 Jan 2010 10:11:01 GMT

Hi, I'm sure this is fairly simple. I have a load script for my GUI that looks like this:

Directory;

LOAD [Assyst Operator ID],

[Resolver Group],

[Company ID],

[Incident ID],

[Assyst Ref No],

[Date Call logged],

[Days since logged],

[Affected User],

[User Referer],

[Affected User Contact No],

Description,

[Callback Remark],

[Call back necessary],

[Call back date],

[Breach Date],

[Date of action resolve],

[Days left over before Breached],

[Close Date],

[Company Name],

[Assyst Section Name],

[Assyst Operator],

[Assyst User Name]

FROM

Data\Incident.qvd

(qvd);

LOAD [Incident ID],

DaysOpen,

Daysloggedgroup

FROM

Data\Groups.qvd

(qvd);

This system is used to monitor call pick ups, however the problem is everytime something changes in the calls details a new row is added, therefore in order to get an accurate count of the number of calls on the go at any one time I need to perform a distinct on just the Incident ID, so instead of there being 10 for incident 549536 with all the rows showing the various details I just get the one row.

Or is there an easy way for me to show it in my graph, at the moment I am using the command COUNT (Incident ID) , this returns some 1500 records for one day when really there are only about 150 due to adding a row for every line of detail changed. Any ideas for those two?

Cheers

Ben

Load distinct on a single column?

Wed, 13 Jan 2010 19:09:14 GMT

Try 'COUNT (DISTINCT Incident ID)' for the graph version. Probably the easiest solution.

topic Load distinct on a single column? in QlikView

Load distinct on a single column?

Load distinct on a single column?