https://community.qlik.com/t5/QlikView/expression-value-listbox-changes-when-one-is-selected/m-p/1774022#M454764 <P>I have a table with the fields year, weeknumber, enddate week</P><P>I have a variablevmaxyear</P><P>In my listbox field weeknumber can be selected and an expression is added :&nbsp;=sum(distinct {&lt;year= {$(vmaxyear)}&gt;enddate_week)</P><P>When no selecttion is made, the enddates are correct presented. When a weeknumber is selected however, the date of the selected weeknumber is presented correctly, but all the other dates give 30-12-1899.I can explain why , but I would like to keep the correct dates presented. Is that possible ?</P><P>SOLVED: changed the expression to :&nbsp;=sum(distinct {<STRONG> weeknumber=</STRONG>, &lt;year= {$(vmaxyear)}&gt;enddate_week)</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 15 Jan 2021 06:38:06 GMT curiousfellow 2021-01-15T06:38:06Z https://community.qlik.com/t5/QlikView/expression-value-listbox-changes-when-one-is-selected/m-p/1774022#M454764 <P>I have a table with the fields year, weeknumber, enddate week</P><P>I have a variablevmaxyear</P><P>In my listbox field weeknumber can be selected and an expression is added :&nbsp;=sum(distinct {&lt;year= {$(vmaxyear)}&gt;enddate_week)</P><P>When no selecttion is made, the enddates are correct presented. When a weeknumber is selected however, the date of the selected weeknumber is presented correctly, but all the other dates give 30-12-1899.I can explain why , but I would like to keep the correct dates presented. Is that possible ?</P><P>SOLVED: changed the expression to :&nbsp;=sum(distinct {<STRONG> weeknumber=</STRONG>, &lt;year= {$(vmaxyear)}&gt;enddate_week)</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 15 Jan 2021 06:38:06 GMT https://community.qlik.com/t5/QlikView/expression-value-listbox-changes-when-one-is-selected/m-p/1774022#M454764 curiousfellow 2021-01-15T06:38:06Z