topic Re: Need Help in QlikView

Need Help

vanderson009 — Fri, 04 Jul 2014 07:34:19 GMT

Hello community,

I have table, in which their is one column as Comment.

Comment

Your network is good

Thanks, you have provide nice service to us

Great network

Superlative service

Sorry I don’t like your service, so bad experience with your network

Suppose i have 5 comments,

Out of that 5, 4 comment contains word as good, nice, great, superlative which should be consider as Excellent

and count of Excellent should be 4. Remaining one comment having word is bad which should be consider as awful,

and count of awful is 1.

How can i overcome this requirement.

Please guide me.

- Thanks and Regards,

Villyee.

MK_QSL — Fri, 04 Jul 2014 07:56:38 GMT

='GOOD COMMENTS : '& SUM(AGGR(IF(WildMatch(UPPER(Comment),'*GREAT*','*SUPERLATIVE*','*NICE*','*GOOD*'),1),Comment)) & CHR(10) &

'BAD COMMENTS : '& SUM(AGGR(IF(NOT WildMatch(UPPER(Comment),'*GREAT*','*SUPERLATIVE*','*NICE*','*GOOD*'),1),Comment))

shane_spencer — Fri, 04 Jul 2014 07:58:35 GMT

I would use Wildmatch and a Mapping Table (or just link an inline table) - n.b. replace Excellent and Bad i.e.

map_Comment_Codes:

LOAD * Inline [
CommentCode, CommentType
0, Excellent

1, Excellent

2, Excellent

3, Excellent

4, Bad

];

wildmatch(Comment,
'*good*',
'*nice*',
'*great*',
'*super*',
'*bad*'
)
// Assigns a unique number (CommentCode) to each Comment Type
as CommentCode