topic Re: formula in QlikView https://community.qlik.com/t5/QlikView/formula/m-p/758463#M1298514 <HTML><HEAD></HEAD><BODY><P>Nothing.</P><P></P><P>Are you sure that in your second experiment, VARIABLEWEEK really contained the value 2? Or was it set to something else? Put a text box on your sheet with the following expression to verify the value of this variable:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">="VARIABLEWEEK = [$(VARIABLEWEEK)]"</SPAN></P></BODY></HTML> Wed, 17 Dec 2014 21:55:07 GMT Peter_Cammaert 2014-12-17T21:55:07Z formula https://community.qlik.com/t5/QlikView/formula/m-p/758462#M1298512 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">I have formula</SPAN></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;">BMIYEAR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(VARIABLEYEAR)"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMIWEEKNR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(VARIABLEWEEK)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} SALES</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>variableyear equals 2013</P><P>variableweek equals 2</P><P>it gives me sales of year 2013 for weeknr 1 and 2</P><P></P><P>but if i do</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;">BMIYEAR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(VARIABLEYEAR)"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMIWEEKNR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(VARIABLEWEEK)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} SALES</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>it doesnot give me sales of year 2013 for week 2, but sales of complete 2013.</P><P></P><P>What do i wrong?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/formula/m-p/758462#M1298512 2026-01-26T18:19:17Z Re: formula https://community.qlik.com/t5/QlikView/formula/m-p/758463#M1298514 <HTML><HEAD></HEAD><BODY><P>Nothing.</P><P></P><P>Are you sure that in your second experiment, VARIABLEWEEK really contained the value 2? Or was it set to something else? Put a text box on your sheet with the following expression to verify the value of this variable:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">="VARIABLEWEEK = [$(VARIABLEWEEK)]"</SPAN></P></BODY></HTML> Wed, 17 Dec 2014 21:55:07 GMT https://community.qlik.com/t5/QlikView/formula/m-p/758463#M1298514 Peter_Cammaert 2014-12-17T21:55:07Z Re: formula https://community.qlik.com/t5/QlikView/formula/m-p/758464#M1298517 <HTML><HEAD></HEAD><BODY><P>2</P></BODY></HTML> Wed, 17 Dec 2014 22:12:16 GMT https://community.qlik.com/t5/QlikView/formula/m-p/758464#M1298517 2014-12-17T22:12:16Z Re: formula https://community.qlik.com/t5/QlikView/formula/m-p/758465#M1298520 <HTML><HEAD></HEAD><BODY><P>Can you post your document, or a reduced version with the same weird behavior?</P></BODY></HTML> Wed, 17 Dec 2014 23:25:01 GMT https://community.qlik.com/t5/QlikView/formula/m-p/758465#M1298520 Peter_Cammaert 2014-12-17T23:25:01Z