https://community.qlik.com/t5/App-Development/Set-analysis-using-dates-derived-dates-that-allow-all-filters/m-p/1686619#M52308 <P>Hi - I have a KPI that shows case count for this week to date from yesterday vs the same period last week (e.g. if today is Friday, show Mon-Thu for this week vs Mon-Thu last week). I also have a date dimension used on a chart called Month-Day that allows drilling down from month to day and is based on the derived fields of LinkDate (e.g. LinkDate.MonthYear)</P><P>I have the following formula for the set analysis which is part of a pick statement (pick uses either PROD or ALL for WhenFoundFlag):</P><P>count({&lt;tblName={'Opened'},[Case.WhenFoundFlag]={'Prod'}, LinkDate={"&gt;=$(=WeekStart(Today(),-1))&lt;=$(=Date(Today()-8,'MM/DD/YYYY'))"}&gt;} DISTINCT Case.Id)</P><P>It seems to pull in the right number, but need to be able to allow it to be filtered by any filters (there are many), but not by the date. When I select a previous month on the chart, it changes the KPI, even though the set analysis is fixed on previous WTD - any ideas on how to do this?</P><P>Thanks!</P> Sat, 21 Mar 2020 01:41:20 GMT Russ 2020-03-21T01:41:20Z https://community.qlik.com/t5/App-Development/Set-analysis-using-dates-derived-dates-that-allow-all-filters/m-p/1686619#M52308 <P>Hi - I have a KPI that shows case count for this week to date from yesterday vs the same period last week (e.g. if today is Friday, show Mon-Thu for this week vs Mon-Thu last week). I also have a date dimension used on a chart called Month-Day that allows drilling down from month to day and is based on the derived fields of LinkDate (e.g. LinkDate.MonthYear)</P><P>I have the following formula for the set analysis which is part of a pick statement (pick uses either PROD or ALL for WhenFoundFlag):</P><P>count({&lt;tblName={'Opened'},[Case.WhenFoundFlag]={'Prod'}, LinkDate={"&gt;=$(=WeekStart(Today(),-1))&lt;=$(=Date(Today()-8,'MM/DD/YYYY'))"}&gt;} DISTINCT Case.Id)</P><P>It seems to pull in the right number, but need to be able to allow it to be filtered by any filters (there are many), but not by the date. When I select a previous month on the chart, it changes the KPI, even though the set analysis is fixed on previous WTD - any ideas on how to do this?</P><P>Thanks!</P> Sat, 21 Mar 2020 01:41:20 GMT https://community.qlik.com/t5/App-Development/Set-analysis-using-dates-derived-dates-that-allow-all-filters/m-p/1686619#M52308 Russ 2020-03-21T01:41:20Z