topic Re: Set unique date ranges on sheets? in App Development https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435003#M34466 <HTML><HEAD></HEAD><BODY><P>If by fields you are referring measure columns, then yup you would need to add the set analysis into the expression for each measure.</P></BODY></HTML> Mon, 18 Sep 2017 16:37:46 GMT Anonymous 2017-09-18T16:37:46Z Set unique date ranges on sheets? https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435002#M34465 <HTML><HEAD></HEAD><BODY><P>I am currently working on an app that will have several sheets within it. The app draws several years worth of data from a view in our Microsoft SQL Server. While each sheet requires the data from the same view, many of them have unique date range requirements. Some example date ranges I need include:</P><UL><LI>A week-over-week report</LI><LI>A month-over-month report</LI><LI>A year-over-year report</LI><LI>A month-to-date report</LI><LI>A weekly report</LI></UL><P></P><P>Since these sheets are all a part of the same app, it looks like I cannot use the load editor to get the date ranges I need. This leads me to believe that a set analysis is what I need. Reading the documentation for set analysis, it appears that it works only on a single field. If I have 10 fields I need to display in a report, would I need to do a set analysis on each field? Is there any way to do a set a date range for all fields in a given table?</P></BODY></HTML> Mon, 18 Sep 2017 16:29:21 GMT https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435002#M34465 Anonymous 2017-09-18T16:29:21Z Re: Set unique date ranges on sheets? https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435003#M34466 <HTML><HEAD></HEAD><BODY><P>If by fields you are referring measure columns, then yup you would need to add the set analysis into the expression for each measure.</P></BODY></HTML> Mon, 18 Sep 2017 16:37:46 GMT https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435003#M34466 Anonymous 2017-09-18T16:37:46Z Re: Set unique date ranges on sheets? https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435004#M34467 <HTML><HEAD></HEAD><BODY><P>I had assumed that there would be a way to do it for a sheet or table and wanted to verify before I dove in. <SPAN style="font-size: 13.3333px;">Thank you for your reply!</SPAN></P></BODY></HTML> Mon, 18 Sep 2017 16:42:56 GMT https://community.qlik.com/t5/App-Development/Set-unique-date-ranges-on-sheets/m-p/1435004#M34467 Anonymous 2017-09-18T16:42:56Z