topic Re: Set Expression with function in QlikView https://community.qlik.com/t5/QlikView/Set-Expression-with-function/m-p/521304#M1134409 <HTML><HEAD></HEAD><BODY><P>No, you can only use field names in on the left side of the = operator. You can create a year field in the script from field B. That's the best approach. Or you can try something like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count( {1&lt;field_b={'=year(field_b)=2000'}&gt;} Distinct Social_Number)</SPAN></P></BODY></HTML> Thu, 24 Oct 2013 16:54:28 GMT Gysbert_Wassenaar 2013-10-24T16:54:28Z Set Expression with function https://community.qlik.com/t5/QlikView/Set-Expression-with-function/m-p/521303#M1134408 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have a "quick chart" where I have graphs with sales by year, this date is related with field A. However I need show number of clients according the last year of enrollment and this date is related with field B therefore I need count all my customers in year (field B) with out have in mind the month in sales (field B). Can I transform a dimension in a set expression?</P><P></P><P>=Count( {1&lt;Year(field_b)={2000}&gt;} Distinct Social_Number)</P><P></P><P>Regards</P><P></P><P>- Javier Florian</P></BODY></HTML> Thu, 24 Oct 2013 16:17:37 GMT https://community.qlik.com/t5/QlikView/Set-Expression-with-function/m-p/521303#M1134408 javier_florian 2013-10-24T16:17:37Z Re: Set Expression with function https://community.qlik.com/t5/QlikView/Set-Expression-with-function/m-p/521304#M1134409 <HTML><HEAD></HEAD><BODY><P>No, you can only use field names in on the left side of the = operator. You can create a year field in the script from field B. That's the best approach. Or you can try something like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count( {1&lt;field_b={'=year(field_b)=2000'}&gt;} Distinct Social_Number)</SPAN></P></BODY></HTML> Thu, 24 Oct 2013 16:54:28 GMT https://community.qlik.com/t5/QlikView/Set-Expression-with-function/m-p/521304#M1134409 Gysbert_Wassenaar 2013-10-24T16:54:28Z