topic Error in expression in QlikView https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/110319#M457528 <HTML><HEAD></HEAD><BODY><P>Hi all i try this but this shows an error</P><P style="text-align: left;"></P><P style="text-align: left;">=If</P><P style="text-align: left;">(</P><P style="text-align: left;">$(vYTD)=1,</P><P style="text-align: left;">'YTD GP ('&amp;Max(Year_U)&amp;'): '&amp;</P><P style="text-align: left;">Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},Month_U=,Quarter_U=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'#,##0.0')</P><P style="text-align: left;">&amp;CHR(10)&amp;</P><P style="text-align: left;">'YTD GP ('&amp;(Max(<SPAN style="font-size: 13.3333px;">Year_U</SPAN>)-1)&amp;'): '&amp;</P><P style="text-align: left;">Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},<SPAN style="font-size: 13.3333px;">Month_U</SPAN>=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'#,##0.0')</P><P style="text-align: left;">&amp;CHR(10)&amp;</P><P style="text-align: left;">'Variance&nbsp; : '&amp; Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vMaxYear)},<SPAN style="font-size: 13.3333px;">Month_U</SPAN>=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM) -</P><P style="text-align: left;">Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},UW_Month=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}<SPAN style="font-size: 13.3333px;">RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- </SPAN><SPAN style="font-size: 13.3333px;">PEff_Date</SPAN><SPAN style="font-size: 13.3333px;">+1)))</SPAN></P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'##,##0')</P><P style="text-align: left;">)</P><P></P><P></P><P><STRONG>Error is </STRONG></P><P><STRONG>Error in express: / is not a valid function</STRONG></P></BODY></HTML> Wed, 17 Oct 2018 05:33:05 GMT usercapricon 2018-10-17T05:33:05Z Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/110319#M457528 <HTML><HEAD></HEAD><BODY><P>Hi all i try this but this shows an error</P><P style="text-align: left;"></P><P style="text-align: left;">=If</P><P style="text-align: left;">(</P><P style="text-align: left;">$(vYTD)=1,</P><P style="text-align: left;">'YTD GP ('&amp;Max(Year_U)&amp;'): '&amp;</P><P style="text-align: left;">Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},Month_U=,Quarter_U=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'#,##0.0')</P><P style="text-align: left;">&amp;CHR(10)&amp;</P><P style="text-align: left;">'YTD GP ('&amp;(Max(<SPAN style="font-size: 13.3333px;">Year_U</SPAN>)-1)&amp;'): '&amp;</P><P style="text-align: left;">Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},<SPAN style="font-size: 13.3333px;">Month_U</SPAN>=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'#,##0.0')</P><P style="text-align: left;">&amp;CHR(10)&amp;</P><P style="text-align: left;">'Variance&nbsp; : '&amp; Num((Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vMaxYear)},<SPAN style="font-size: 13.3333px;">Month_U</SPAN>=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}</P><P style="text-align: left;">RangeMax(0,RangeMin((<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1),($(vPE_Date)- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+1)))</P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM) -</P><P style="text-align: left;">Sum({&lt;<SPAN style="font-size: 13.3333px;">Year_U</SPAN>= {$(vPrevYear)},UW_Month=,<SPAN style="font-size: 13.3333px;">Quarter_U</SPAN>=&gt;}<SPAN style="font-size: 13.3333px;">RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- </SPAN><SPAN style="font-size: 13.3333px;">PEff_Date</SPAN><SPAN style="font-size: 13.3333px;">+1)))</SPAN></P><P style="text-align: left;">/ (<SPAN style="font-size: 13.3333px;">PEX_Date</SPAN>- <SPAN style="font-size: 13.3333px;">PEff_Date</SPAN>+ 1)*GROSS_PREMIUM)),'##,##0')</P><P style="text-align: left;">)</P><P></P><P></P><P><STRONG>Error is </STRONG></P><P><STRONG>Error in express: / is not a valid function</STRONG></P></BODY></HTML> Wed, 17 Oct 2018 05:33:05 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/110319#M457528 usercapricon 2018-10-17T05:33:05Z