topic Error in expression ')' expected in QlikView https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409992#M810708 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Any suggestions on why I'm getting this error message:</P><P></P><P>=Sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])/(sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])+ sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases Unbillable]))</P><P></P><P>Thank you!</P><P></P><P>Megan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT megan_deboer 2020-11-25T16:16:04Z Error in expression ')' expected https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409992#M810708 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Any suggestions on why I'm getting this error message:</P><P></P><P>=Sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])/(sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])+ sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases Unbillable]))</P><P></P><P>Thank you!</P><P></P><P>Megan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409992#M810708 megan_deboer 2020-11-25T16:16:04Z Re: Error in expression ')' expected https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409993#M810709 <HTML><HEAD></HEAD><BODY><P>Try below expression. You missed the Set Modifier and braces.</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month.autoCalendar.YearMonth]</SPAN><SPAN style="font-size: 8pt;"> = {'2017-May'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Cases-Verified]</SPAN><SPAN style="font-size: 8pt;">)/(sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month.autoCalendar.YearMonth]</SPAN><SPAN style="font-size: 8pt;"> = {'2017-May'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Cases-Verified]</SPAN><SPAN style="font-size: 8pt;">)+ sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month.autoCalendar.YearMonth]</SPAN><SPAN style="font-size: 8pt;"> = {'2017-May'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Cases Unbillable]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Fri, 06 Oct 2017 19:12:08 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409993#M810709 krishnacbe 2017-10-06T19:12:08Z Re: Error in expression ')' expected https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409994#M810710 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>=Sum(<SPAN style="color: #ff0000;">{&lt;</SPAN>[Month.autoCalendar.YearMonth] = {'2017-May'}<SPAN style="color: #ff0000;">&gt;}</SPAN> [Cases-Verified])/(sum(<STRONG style="color: #ff0000; font-size: 13.3333px;">{&lt;</STRONG>[Month.autoCalendar.YearMonth] = {'2017-May'}<STRONG style="color: #ff0000; font-size: 13.3333px;">&gt;}</STRONG> [Cases-Verified]) + Sum(<STRONG style="color: #ff0000; font-size: 13.3333px;">{&lt;</STRONG>[Month.autoCalendar.YearMonth] = {'2017-May'}<STRONG style="color: #ff0000; font-size: 13.3333px;">&gt;}</STRONG> [Cases Unbillable]))</STRONG></P></BODY></HTML> Fri, 06 Oct 2017 19:12:52 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409994#M810710 sunny_talwar 2017-10-06T19:12:52Z Re: Error in expression ')' expected https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409995#M810711 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 06 Oct 2017 19:15:22 GMT https://community.qlik.com/t5/QlikView/Error-in-expression-expected/m-p/1409995#M810711 megan_deboer 2017-10-06T19:15:22Z