topic Invalid expression in QlikView https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460781#M610971 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">I have this error , and i dont know whet the problem<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Invalid expression</SPAN></P><P><SPAN style="font-size: 13.3333px;">accountfinal:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD </SPAN></P><P><SPAN style="font-size: 13.3333px;">( COMPTE_ID ),</SPAN></P><P><SPAN style="font-size: 13.3333px;"> CLIENT_ID,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_CLIENT,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CATEGORIE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_INTITULE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_DEVISE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CODE_LIMITE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_AGENCE_T24,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_SOLDE_REEL,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_RECORD_STATUS,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_AUTHORISER,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_AGENCE_COMPTABLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_INTERET,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_FUSION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_GROUPE_CONDITION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_INACTIV,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_SOLDE_COMPTABLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">MAX( COMPTE_SOLDE_DISPONIBLE) as COMPTE_SOLDE_DISPONIBLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_COMMISSION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_CLOTURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_OUVERTURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_NATURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_PRIME_FIDELITE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_PORTEFEUILLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_TIME,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_NUM_CTOS,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_RIB,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_NUM_TRANSFER,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_MONTANT_BLOQUE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CASH_POOL,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_CATEGORIE_DESCRIPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_LIMITE_DESCRIPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_RESTRICTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_OPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_SOLDE_COMPTABLE_TND,</SPAN></P><P><SPAN style="font-size: 13.3333px;">TEST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">resident ACCOUNT</SPAN></P><P><SPAN style="font-size: 13.3333px;">group by COMPTE_ID </SPAN></P></BODY></HTML> Mon, 08 Jan 2018 15:40:29 GMT souadouert 2018-01-08T15:40:29Z Invalid expression https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460781#M610971 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">I have this error , and i dont know whet the problem<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Invalid expression</SPAN></P><P><SPAN style="font-size: 13.3333px;">accountfinal:</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD </SPAN></P><P><SPAN style="font-size: 13.3333px;">( COMPTE_ID ),</SPAN></P><P><SPAN style="font-size: 13.3333px;"> CLIENT_ID,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_CLIENT,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CATEGORIE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_INTITULE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_DEVISE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CODE_LIMITE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_AGENCE_T24,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_SOLDE_REEL,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_RECORD_STATUS,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_AUTHORISER,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_AGENCE_COMPTABLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_INTERET,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_FUSION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_GROUPE_CONDITION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_INACTIV,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_SOLDE_COMPTABLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">MAX( COMPTE_SOLDE_DISPONIBLE) as COMPTE_SOLDE_DISPONIBLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_COMMISSION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_CLOTURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_OUVERTURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_NATURE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_PRIME_FIDELITE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_PORTEFEUILLE,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_DATE_TIME,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_NUM_CTOS,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_RIB,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_NUM_TRANSFER,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_MONTANT_BLOQUE,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_CASH_POOL,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_CATEGORIE_DESCRIPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_LIMITE_DESCRIPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_RESTRICTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"> COMPTE_OPTION,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">COMPTE_SOLDE_COMPTABLE_TND,</SPAN></P><P><SPAN style="font-size: 13.3333px;">TEST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">resident ACCOUNT</SPAN></P><P><SPAN style="font-size: 13.3333px;">group by COMPTE_ID </SPAN></P></BODY></HTML> Mon, 08 Jan 2018 15:40:29 GMT https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460781#M610971 souadouert 2018-01-08T15:40:29Z Re: Invalid expression https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460782#M610972 <HTML><HEAD></HEAD><BODY><P>Group By should include all non aggregate fields which cover, Perhaps this</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>accountfinal:</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">LOAD</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">( COMPTE_ID ),</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">CLIENT_ID,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CLIENT,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTITULE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DEVISE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CODE_LIMITE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_T24,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_REEL,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RECORD_STATUS,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AUTHORISER,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_COMPTABLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTERET,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_FUSION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_GROUPE_CONDITION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INACTIV,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_COMPTABLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">MAX( COMPTE_SOLDE_DISPONIBLE) as COMPTE_SOLDE_DISPONIBLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_COMMISSION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_CLOTURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_OUVERTURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NATURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PRIME_FIDELITE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PORTEFEUILLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_TIME,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_CTOS,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RIB,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_TRANSFER,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_MONTANT_BLOQUE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CASH_POOL,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE_DESCRIPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_LIMITE_DESCRIPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RESTRICTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_OPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_COMPTABLE_TND,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">TEST</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">resident ACCOUNT</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>group by</STRONG> </SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG style="color: #ff0000;">( COMPTE_ID ),</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">CLIENT_ID,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CLIENT,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTITULE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DEVISE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CODE_LIMITE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_T24,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_REEL,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RECORD_STATUS,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AUTHORISER,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_COMPTABLE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTERET,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_FUSION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_GROUPE_CONDITION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INACTIV,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_COMPTABLE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_COMMISSION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_CLOTURE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_OUVERTURE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NATURE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PRIME_FIDELITE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PORTEFEUILLE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_TIME,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_CTOS,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RIB,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_TRANSFER,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_MONTANT_BLOQUE,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CASH_POOL,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE_DESCRIPTION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_LIMITE_DESCRIPTION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RESTRICTION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_OPTION,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_COMPTABLE_TND,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG style="color: #ff0000;">TEST;</STRONG></SPAN></P></BODY></HTML> Mon, 08 Jan 2018 15:44:18 GMT https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460782#M610972 Anil_Babu_Samineni 2018-01-08T15:44:18Z Re: Invalid expression https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460783#M610973 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You must add all the fields in group by</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">accountfinal:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">LOAD</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">( COMPTE_ID ),</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">CLIENT_ID,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_CLIENT,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_CATEGORIE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_INTITULE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_DEVISE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_CODE_LIMITE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_AGENCE_T24,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_SOLDE_REEL,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_RECORD_STATUS,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_AUTHORISER,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_AGENCE_COMPTABLE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_INTERET,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_FUSION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_GROUPE_CONDITION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_INACTIV,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_SOLDE_COMPTABLE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">MAX( COMPTE_SOLDE_DISPONIBLE) as COMPTE_SOLDE_DISPONIBLE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_COMMISSION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_DATE_CLOTURE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_DATE_OUVERTURE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_NATURE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_PRIME_FIDELITE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_PORTEFEUILLE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_DATE_TIME,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_NUM_CTOS,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_RIB,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_NUM_TRANSFER,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_MONTANT_BLOQUE,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_CASH_POOL,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_CATEGORIE_DESCRIPTION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_LIMITE_DESCRIPTION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_RESTRICTION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_OPTION,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_SOLDE_COMPTABLE_TND,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">TEST</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">resident ACCOUNT</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">group by COMPTE_ID,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>CLIENT_ID,</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CLIENT,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTITULE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DEVISE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CODE_LIMITE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_T24,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_REEL,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RECORD_STATUS,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AUTHORISER,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_AGENCE_COMPTABLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INTERET,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_FUSION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_GROUPE_CONDITION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_INACTIV,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_SOLDE_COMPTABLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_COMMISSION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_CLOTURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_OUVERTURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NATURE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PRIME_FIDELITE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_PORTEFEUILLE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_DATE_TIME,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_CTOS,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RIB,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_NUM_TRANSFER,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_MONTANT_BLOQUE,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CASH_POOL,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_CATEGORIE_DESCRIPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_LIMITE_DESCRIPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_RESTRICTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13.3333px; font-style: inherit; font-family: inherit;">COMPTE_OPTION,</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN><SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">COMPTE_SOLDE_COMPTABLE_TND,</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>TEST</STRONG></SPAN></P></BODY></HTML> Mon, 08 Jan 2018 15:46:06 GMT https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/1460783#M610973 ElizaF 2018-01-08T15:46:06Z