topic Multiple Date ranges in one sheet in QlikView https://community.qlik.com/t5/QlikView/Multiple-Date-ranges-in-one-sheet/m-p/488327#M1145608 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm having trouble replicating the following charts in qlikview. My issue is calculating for the range only. For example I want to see the defects grouped by</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1) Last week</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2) Last 3 Months</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3) Rolling 12 Months</P><P>on the same sheet, currently all graphs show the same data in qlikview</P><P></P><P>Current Dimention is Date&nbsp; or Month/Year for each chart</P><P>Expressions sum the defects for particular Models (~20). I would like to create a report and cycle through the models for each page. Detaching each chart is not an option.</P><P></P><P></P><P></P><P><IMG __jive_id="44104" class="jive-image-thumbnail jive-image" onclick="" alt="Defect Example.JPG" src="/legacyfs/online/44104_Defect Example.JPG" width="450" /></P></BODY></HTML> Wed, 17 Jul 2013 09:06:03 GMT 2013-07-17T09:06:03Z Multiple Date ranges in one sheet https://community.qlik.com/t5/QlikView/Multiple-Date-ranges-in-one-sheet/m-p/488327#M1145608 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm having trouble replicating the following charts in qlikview. My issue is calculating for the range only. For example I want to see the defects grouped by</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1) Last week</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2) Last 3 Months</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3) Rolling 12 Months</P><P>on the same sheet, currently all graphs show the same data in qlikview</P><P></P><P>Current Dimention is Date&nbsp; or Month/Year for each chart</P><P>Expressions sum the defects for particular Models (~20). I would like to create a report and cycle through the models for each page. Detaching each chart is not an option.</P><P></P><P></P><P></P><P><IMG __jive_id="44104" class="jive-image-thumbnail jive-image" onclick="" alt="Defect Example.JPG" src="/legacyfs/online/44104_Defect Example.JPG" width="450" /></P></BODY></HTML> Wed, 17 Jul 2013 09:06:03 GMT https://community.qlik.com/t5/QlikView/Multiple-Date-ranges-in-one-sheet/m-p/488327#M1145608 2013-07-17T09:06:03Z