https://community.qlik.com/t5/QlikView/To-exclude-a-filter-with-an-if/m-p/1850552#M1215616 <P>Hello,<BR />I have a filter to which a condition is applied:<BR />if(pkeysPENLS=0,Null(),[action_date.autoCalendar.Year])</P> <P><BR />I have to exclude this filter from a measure:<BR />Sum({$&lt;[action_date.autoCalendar.Year]=&gt;} collections)<BR /><BR />but it does not work. What is the right syntax?<BR />Thanks!</P> Fri, 22 Oct 2021 09:23:08 GMT Aika 2021-10-22T09:23:08Z https://community.qlik.com/t5/QlikView/To-exclude-a-filter-with-an-if/m-p/1850552#M1215616 <P>Hello,<BR />I have a filter to which a condition is applied:<BR />if(pkeysPENLS=0,Null(),[action_date.autoCalendar.Year])</P> <P><BR />I have to exclude this filter from a measure:<BR />Sum({$&lt;[action_date.autoCalendar.Year]=&gt;} collections)<BR /><BR />but it does not work. What is the right syntax?<BR />Thanks!</P> Fri, 22 Oct 2021 09:23:08 GMT https://community.qlik.com/t5/QlikView/To-exclude-a-filter-with-an-if/m-p/1850552#M1215616 Aika 2021-10-22T09:23:08Z