Aggregate Data in a Field

Anonymous — Wed, 29 Feb 2012 09:55:03 GMT

I have a FIELD named CallDescription, which has successful descriptions (script placed) and unsuccessful descriptions (ie do not want[reason1],do not want[reason2], do not call again, wrong number)

Is there a way to aggregate the unsuccessful descriptions, so I can show charts that compare successful VS unsuccessful calls?

Aggregate Data in a Field

swuehl — Wed, 29 Feb 2012 13:10:06 GMT

Chris,

probably yes, assuming that not both description types are completely showing free text (then you probably need some kind of sentiment analysis).

I' not sure what you mean with 'script placed', is this already one of / the only successful description?

You could create a table of your defined successful descriptions:

DESCTABLE:

MAPPING LOAD

F1, 'Successful' as F2

INLINE [

script placed

software installed

just success

];

LOAD

CallDescription,

applymap('DESCTABLE', CallDescription, 'Unsuccessful') as Status,

...

from Table;

Thus, if all successful descriptions are listed in the mapping table, you will create a Status field only having two possible states, Successful and Unsuccessful from that.

This will allow you to directly compare your successful vs unsuccesful calls.

Hope this helps,

Stefan

topic Aggregate Data in a Field in QlikView

Aggregate Data in a Field

Aggregate Data in a Field