https://community.qlik.com/t5/App-Development/background-set-analysis-issue-qlik-sense/m-p/1555370#M40052 <P>Hi</P><P>i have the following as the normal set analysis for my table&nbsp;</P><P>&nbsp;</P><P><SPAN>1. Count({$&lt;date_of_order = {'&gt;=$(=vPreviousMonthStart) &lt;=$(=vPreviousMonthEnd)'}&gt;}[OrderID])</SPAN></P><P>&nbsp;</P><P><SPAN>2. then in the background for that column i have an if statement to colour certain dates based on condtions i.e if date is this week, its red, next week yellow, and anything before that green.&nbsp;</SPAN></P><P><SPAN>but now all dates are being returning all dates in the table as it looks like the 1. is being ignored..</SPAN></P><P>any ideas how to resolve please</P> Tue, 21 Dec 2021 20:05:52 GMT joeybird 2021-12-21T20:05:52Z https://community.qlik.com/t5/App-Development/background-set-analysis-issue-qlik-sense/m-p/1555370#M40052 <P>Hi</P><P>i have the following as the normal set analysis for my table&nbsp;</P><P>&nbsp;</P><P><SPAN>1. Count({$&lt;date_of_order = {'&gt;=$(=vPreviousMonthStart) &lt;=$(=vPreviousMonthEnd)'}&gt;}[OrderID])</SPAN></P><P>&nbsp;</P><P><SPAN>2. then in the background for that column i have an if statement to colour certain dates based on condtions i.e if date is this week, its red, next week yellow, and anything before that green.&nbsp;</SPAN></P><P><SPAN>but now all dates are being returning all dates in the table as it looks like the 1. is being ignored..</SPAN></P><P>any ideas how to resolve please</P> Tue, 21 Dec 2021 20:05:52 GMT https://community.qlik.com/t5/App-Development/background-set-analysis-issue-qlik-sense/m-p/1555370#M40052 joeybird 2021-12-21T20:05:52Z