https://community.qlik.com/t5/Featured-Members/Month-field-comparison-issue/m-p/2556863#M522 <P>It's not quite clear what you want to do but if it's the aim to count anything within a certain month you couldn't show it against another month. Means data belonging to Sep aren't showable to Jun or Jul. It's not a matter of selections else of the right associations between them.</P> Mon, 28 Sep 2026 10:52:28 GMT marcus_sommer 2026-09-28T10:52:28Z https://community.qlik.com/t5/Featured-Members/Month-field-comparison-issue/m-p/2556857#M521 <P>Count({&lt; <FONT color="#FF0000"><STRONG>Month_Patrolling_On={'Sep'},</STRONG></FONT><BR />Year_Patrolling_On={$(vCurrYear)}, PatrollingTypeName={"XYZ"}<BR />&gt;<BR />}DISTINCT Tower_Id)<BR /><BR />The above script isn't working.<BR /><STRONG>ISSUE:</STRONG> highlighted in <FONT color="#FF0000">RED&nbsp;<FONT color="#000000">. This part is not evaluating as expected. If I remove the RED part, It works fine, but i need the data for current month only.<BR /><BR /><STRONG>REFERENCE:</STRONG> (SS from my table. All 3 fields are tagged <EM>$integer $numeric</EM>)</FONT></FONT></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bpraveen_0-1790587504950.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/190382i27C9F73B6AE066FF/image-size/medium?v=v2&amp;px=400" role="button" title="bpraveen_0-1790587504950.png" alt="bpraveen_0-1790587504950.png" /></span></P><P>&nbsp;</P> Mon, 28 Sep 2026 09:28:58 GMT https://community.qlik.com/t5/Featured-Members/Month-field-comparison-issue/m-p/2556857#M521 bpraveen 2026-09-28T09:28:58Z https://community.qlik.com/t5/Featured-Members/Month-field-comparison-issue/m-p/2556863#M522 <P>It's not quite clear what you want to do but if it's the aim to count anything within a certain month you couldn't show it against another month. Means data belonging to Sep aren't showable to Jun or Jul. It's not a matter of selections else of the right associations between them.</P> Mon, 28 Sep 2026 10:52:28 GMT https://community.qlik.com/t5/Featured-Members/Month-field-comparison-issue/m-p/2556863#M522 marcus_sommer 2026-09-28T10:52:28Z