topic Syntax for Sum statement in QlikView https://community.qlik.com/t5/QlikView/Syntax-for-Sum-statement/m-p/325448#M497007 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';">Hi, </SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';"> </SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';">I'm struggeling with the folowing:</SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">What is the correct syntax for replacing value 3 with </SPAN>$(variable) in the line below?</SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">Sum</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">( {&lt;</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Year</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">={2009}, </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Month</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">={</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">"&lt;=3"</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;}</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">LINEAMOUNTMST</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; font-size: 10pt;"> </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Thanks in advance!</SPAN></P></BODY></HTML> Tue, 27 Dec 2011 13:17:02 GMT 2011-12-27T13:17:02Z Syntax for Sum statement https://community.qlik.com/t5/QlikView/Syntax-for-Sum-statement/m-p/325448#M497007 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';">Hi, </SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';"> </SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';">I'm struggeling with the folowing:</SPAN></P><P><SPAN style="color: blue; font-size: 9pt; font-family: 'Courier New';"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">What is the correct syntax for replacing value 3 with </SPAN>$(variable) in the line below?</SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">Sum</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">( {&lt;</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Year</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">={2009}, </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Month</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">={</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">"&lt;=3"</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">}&gt;}</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">LINEAMOUNTMST</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; font-size: 10pt;"> </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Thanks in advance!</SPAN></P></BODY></HTML> Tue, 27 Dec 2011 13:17:02 GMT https://community.qlik.com/t5/QlikView/Syntax-for-Sum-statement/m-p/325448#M497007 2011-12-27T13:17:02Z Syntax for Sum statement https://community.qlik.com/t5/QlikView/Syntax-for-Sum-statement/m-p/325449#M497008 <HTML><HEAD></HEAD><BODY><P>Try this below expression </P><P></P><P><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">( {&lt;</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: maroon;">Year</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">={2009}, </SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: maroon;">Month</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&lt;=<SPAN style="color: #0000ff; font-family: 'Courier New'; font-size: 12px; background-color: #eef4f9;">$(variable)</SPAN>"</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">}&gt;}</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: maroon;">LINEAMOUNTMST</SPAN><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">)</SPAN></P><P></P><P><SPAN style="background-color: #eef4f9; font-size: 9pt; font-family: 'Courier New'; color: black;">-Sridhar<BR /></SPAN></P></BODY></HTML> Tue, 27 Dec 2011 13:23:19 GMT https://community.qlik.com/t5/QlikView/Syntax-for-Sum-statement/m-p/325449#M497008 sridhar240784 2011-12-27T13:23:19Z