topic Quarters in QlikView https://community.qlik.com/t5/QlikView/Quarters/m-p/1407408#M426031 <HTML><HEAD></HEAD><BODY><P>How derive the quarters,months using this filed</P><P>and</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">but my requirement is derive physical quarters and every quarter have 13 weeks of data but I want</P><P></P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">showing like&nbsp; Q1-1,2,3.......13</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">Q2&nbsp; also like--1,2,3,4,5,........13</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">every quarter comes like this way</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181953_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 03 Nov 2017 07:35:16 GMT Anonymous 2017-11-03T07:35:16Z Quarters https://community.qlik.com/t5/QlikView/Quarters/m-p/1407408#M426031 <HTML><HEAD></HEAD><BODY><P>How derive the quarters,months using this filed</P><P>and</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">but my requirement is derive physical quarters and every quarter have 13 weeks of data but I want</P><P></P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">showing like&nbsp; Q1-1,2,3.......13</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">Q2&nbsp; also like--1,2,3,4,5,........13</P><P style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; text-align: left; color: #3d3d3d; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; vertical-align: baseline; white-space: normal; orphans: 2; widows: 2; background-color: #ffffff; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">every quarter comes like this way</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181953_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 03 Nov 2017 07:35:16 GMT https://community.qlik.com/t5/QlikView/Quarters/m-p/1407408#M426031 Anonymous 2017-11-03T07:35:16Z Re: Quarters https://community.qlik.com/t5/QlikView/Quarters/m-p/1407409#M426032 <HTML><HEAD></HEAD><BODY><P>Check the attached.</P><P></P><P></P><P><IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181960_sample.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 03 Nov 2017 08:09:25 GMT https://community.qlik.com/t5/QlikView/Quarters/m-p/1407409#M426032 techvarun 2017-11-03T08:09:25Z Re: Quarters https://community.qlik.com/t5/QlikView/Quarters/m-p/1407410#M426033 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Expression: <SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">'Q 0' &amp; </SPAN><SPAN style="font-size: 13.3333px;"><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Ceil</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Right</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">ShipMonth</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;">,2)/3)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;">option 2</SPAN></SPAN></P><P></P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">tbl:<BR /> </SPAN><STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">LOAD</SPAN></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> *, <SPAN style="text-decoration: underline;">'Q 0' &amp; </SPAN></SPAN><SPAN style="text-decoration: underline;"><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue; text-decoration: underline;">Ceil</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black; text-decoration: underline;">(</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue; text-decoration: underline;">Right</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black; text-decoration: underline;">(</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: maroon; text-decoration: underline;">ShipMonth</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black; text-decoration: underline;">,2)/3) </SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue; text-decoration: underline;">AS</SPAN> <SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: maroon; text-decoration: underline;">Quarter</SPAN></SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="text-decoration: underline;">;</SPAN><BR /> </SPAN><STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">LOAD</SPAN></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> <BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> ShipMonth<BR /> 2017-01<BR /> 2017-02<BR /> 2017-03<BR /> 2017-04<BR /> 2017-05<BR /> 2017-06<BR /> 2017-07<BR /> 2017-08<BR /> 2017-09<BR /> 2017-10<BR /> 2017-11<BR /> 2017-12<BR /> ]</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">;<BR /> </SPAN><STRONG> <IMG alt="QTR.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182023_QTR.png" style="height: auto;" /></STRONG></P></BODY></HTML> Fri, 03 Nov 2017 15:37:47 GMT https://community.qlik.com/t5/QlikView/Quarters/m-p/1407410#M426033 el_aprendiz111 2017-11-03T15:37:47Z