topic Re: loaded a table ? how it works? in QlikView

loaded a table ? how it works?

Anonymous — Mon, 13 Oct 2014 10:44:26 GMT

here @12:n is field in one table and after loading the table i am writing condition like this

where index (@12:n,'\gmaop')<1 or index (@12:n,'*_new_yesuse*') <>1

Re: loaded a table ? how it works?

Mon, 13 Oct 2014 10:51:36 GMT

index function tells the position of substring.

index (@12:n,'\gmaop')<1 or index (@12:n,'*_new_yesuse*') <>1

index (@12:n,'\gmaop')<1 :

this condition will return the records if field @12:n contains value'\gmaop' at first place means all records starting with value'\gmaop'

index (@12:n,'*_new_yesuse*') <>1

this condition will return records which are not started with value '*_new_yesuse*'.

Re: loaded a table ? how it works?

Mon, 13 Oct 2014 10:56:17 GMT

Sorry first condition result should

index (@12:n,'\gmaop')<1 :

this condition will return the records if field @12:n contains value'\gmaop' at first place means all records starting with value'\gmaop' -- this one wrong

this condition will return records which do not contain value '\gmaop'.

Re: loaded a table ? how it works?

Anonymous — Mon, 13 Oct 2014 10:58:23 GMT

Re: loaded a table ? how it works?

Anonymous — Mon, 13 Oct 2014 11:01:13 GMT

Pls explain me with proper answer once again i am confused?