topic Re: Error ')' expected - Qlikview in App Development

Error ')' expected - Qlikview

CamilleA — Thu, 29 Sep 2022 07:32:17 GMT

Hello,

I've got an issue on a tab, when I active this expression :

=SUM(DISTINCT(IF(REGL_MODE_REG='PRELEVEMENT' and Monthstart(REGL_DATE)=PERIODE_DEBUT, REGL_MONTANT)))

I've got the message "Error in expression : ')' expected".

Can I have some help please ? I don't know what s wrong with this expression.

Thank you 🙂

Mark_Little — Thu, 29 Sep 2022 10:39:59 GMT

What are you trying to do?

The brackets seem fine, so to me it points failing to evaluate expression

marcus_sommer — Thu, 29 Sep 2022 11:29:46 GMT

Does this work?

SUM(DISTINCT IF(REGL_MODE_REG='PRELEVEMENT' and Monthstart(REGL_DATE)=PERIODE_DEBUT, REGL_MONTANT))

- Marcus