Syntaxe error

[#1]

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

or

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

Best regards

[avinashelite]

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

[crusader_]

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

[Anonymous · Accepted solution]

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.