topic Re: expr explination? in QlikView

expr explination?

Anonymous — Wed, 03 Dec 2014 11:37:20 GMT

where index(@17:n,'\zabcd67')<1 or index(@17:n,'*_new_one*')<>1;

how it works ? pls explain me

its_anandrjs — Wed, 03 Dec 2014 12:35:07 GMT

Hi,

I thing this expression in the field @17:n is index of \zabcd67 or position is < 1 or index of *_new_one* is not equal to 1

then the where condition is true otherwise false.

But it seems the conditional expression is not correct

where index(@17:n,'\zabcd67')<1 or index(@17:n,'*_new_one*')<>1;

Regards

Anand

Anonymous — Wed, 03 Dec 2014 12:54:36 GMT

expression is correct only