4 Replies Latest reply: Oct 17, 2011 7:33 AM by fmst44000 RSS

    Single quote in a count expression

      Hi,

       

      I'm new to QlikView and I need help.

      I want to count some products agreeing a condition with a single quote.

       

      Example :

           "count({$ <CONTRACT={'Négociation en cours en vue d'un contrat'}> } DISTINCT PRODUCT)"

       

      This : "count({$ <CONTRACT={'Négociation en cours en vue d'& chr(39) &'un contrat'}> } DISTINCT PRODUCT)" doesn't work.

       

      Any idea ?

      Thanks !