User Defined Groups Based on Wildmatch String function

Tue, 14 Jun 2011 12:26:43 GMT

Hi All,

I am wondering if it is possible for qlikview to define user groupings based on input. For example, right now the calculation is hardcoded something like:

IF(wildmatch(Description,'*a*','*b*'), 'P1',

IF(wildmatch(Description,'*c*','*d*'), 'P2', null()) as Priority

What I would like to happen if possible is to read the '*a*','*b*' list in from some external file that the user can maintain. I created a test excel file, that basically just has the label P1, and then two rows of data - a and b. My idea was to use Let to store the string in a variable and the concat function to mash the values together in a string as follows:

Let vRequestedTarget=chr(39)&'*'&concat(RequestedTargetKW,'*'&chr(39)&','&chr(39)&'*');

This throws an error though- "Aggregation expressions not allowed in GROUP BY clause" - so I think I am missing something there.

The the expression would be like:

IF(wildmatch(Description,$vP1String), 'P1',

IF(wildmatch(Description,'*c*','*d*'), 'P2', null()) as Priority

This last part doesn't really matter though, since I can't get the Let statement to work.

Any ideas?

topic User Defined Groups Based on Wildmatch String function in QlikView

User Defined Groups Based on Wildmatch String function