topic Match Function on Interger in QlikView

Match Function on Interger

Anonymous — Mon, 29 Feb 2016 11:23:12 GMT

Hi All,

I'm using the match function in an IF statement (see below),

and was wondering if this is the optimal way to do it,

I'm having second thoughts since it takes alot of time to evaluate the results

(IF(match(PageType, '1', '4', '5', '8', '16', '20', '22', '23', '24', '24'),1 , 0)

Chanty4u — Mon, 29 Feb 2016 11:28:13 GMT

did u try remvng the single quotes?

MayilVahanan — Mon, 29 Feb 2016 11:30:21 GMT

Suppose if you are using in same condition in different location, then try like this. Store in the variable and use wherever you need.

Its number, no need for single quotes.

Set vNumber = 1, 4, 5, 8, 16, 20, 22, 23, 24, 24;

Load *, If(match(PageType, $(vNumber) ),1 , 0) as Flag Inline

[

PageType

];

Anonymous — Mon, 29 Feb 2016 12:08:09 GMT

Removing quotes did not changed the evaluation time, (about 23 minutes)

Anonymous — Mon, 29 Feb 2016 12:14:29 GMT

your expression is write try your expression but small change 1,0 but the your column name and try that way

Anonymous — Mon, 29 Feb 2016 12:15:05 GMT

(IF(match(PageType, '1', '4', '5', '8', '16', '20', '22', '23', '24', '24'),PageType)

try this expression