topic Re: Syntaxe error in QlikView

Syntaxe error

Fri, 25 Jul 2014 07:39:57 GMT

Hi everybody,

Some in see the error cause i don't see it

Error in expression:

')' expected

FLux:

LOAD FLUX_ANNEE,

FLUX_MOIS,

FLUX_JOUR,

FLUX_COMPTE,

FLUX_NUM_PIECE,

FLUX_NUM_ECRITURE,

FLUX_CODE_OPERATION,

FLUX_NUM_OPERATION,

FLUX_EVENNEMENT,

FLUX_MONTANT,

FLUX_CODANA,

THEO_TVA,

TAUX_TVA,

FLUX_CODE_CLIENT,

FLUX_TYPE_COMPTE,

FLUX_TAXE

FROM

C:\Qlikview\Workspace\Sources_Documents\Direction_Financiere\Comptabilite\TVA\QVD\LOADER\flux.qvd

(qvd)

where

FLUX_TYPE_COMPTE='P'

and

(substringcount(*DI*ZA*ZF*ZJC01PPD,RPCPRO,FLUX_CODE_OPERATION) =0

substringcount(*CGBIL,(FLUX_CODE_OPERATION+FLUX_EVENNEMENT)) =0)

Best regards

Re: Syntaxe error

avinashelite — Fri, 25 Jul 2014 07:42:48 GMT

Hi Fahd,

It might be the error in your where condition, please check with it.

please post your qvd file so that we can also try

Regards,

@vi

Re: Syntaxe error

crusader_ — Fri, 25 Jul 2014 09:50:12 GMT

Hi,

Check your Substringcount() function syntax.

From QV help:

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

Kind regards,

Andrei

Re: Syntaxe error

Anonymous — Fri, 25 Jul 2014 10:16:01 GMT

The text string used in the SubStringCount() function should be in single quotes and I am pretty sure it does not accept wildcards, if that is what the * is meant for.