topic Loading customized data for quarter in QlikView https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165928#M38070 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When we use the quarter function in Qlikview, we get months 1,2,3 as Q1 ... 4,5,6 as Q2 etc..</P><P></P><P>My requirement is to load months 4,5,6 as Q1 ... 7,8,9 as Q2 ... 10,11,12 as Q3 and 1,2,3 as Q4.. I want to do this in the load script..</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P><P>Sakshat</P></BODY></HTML> Sat, 30 Oct 2010 16:05:13 GMT 2010-10-30T16:05:13Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165928#M38070 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When we use the quarter function in Qlikview, we get months 1,2,3 as Q1 ... 4,5,6 as Q2 etc..</P><P></P><P>My requirement is to load months 4,5,6 as Q1 ... 7,8,9 as Q2 ... 10,11,12 as Q3 and 1,2,3 as Q4.. I want to do this in the load script..</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P><P>Sakshat</P></BODY></HTML> Sat, 30 Oct 2010 16:05:13 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165928#M38070 2010-10-30T16:05:13Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165929#M38071 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just to add, I have tried using the If statement and LOAD INLINE...</P><P></P><P>though the If statement works, it is too long... Any shorter way to do this would be great!</P></BODY></HTML> Sat, 30 Oct 2010 16:09:38 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165929#M38071 2010-10-30T16:09:38Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165930#M38072 <HTML><HEAD></HEAD><BODY><P>This will work, if Month is a numeric representation of month:<BR />ceil((mod((Month+9),12))/3)<BR />If you base it on date, it will be:<BR />ceil((mod((month(Date)+9),12))/3)</P></BODY></HTML> Sat, 30 Oct 2010 17:39:13 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165930#M38072 Anonymous 2010-10-30T17:39:13Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165931#M38073 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>Thanks for your reply. This formula works for all months except month 3 <IMG alt="Sad" src="http://community.qlik.com/emoticons/emotion-6.gif" /> ..... there it evaluates to Q0</P><P></P><P>--Sakshat</P></BODY></HTML> Sat, 30 Oct 2010 18:28:44 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165931#M38073 2010-10-30T18:28:44Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165932#M38074 <HTML><HEAD></HEAD><BODY><P>Sorry, try this:<BR />ceil((mod(Month+<STRONG>8</STRONG>,12)<STRONG>+1</STRONG>)/3)</P></BODY></HTML> Sat, 30 Oct 2010 19:02:05 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165932#M38074 Anonymous 2010-10-30T19:02:05Z Loading customized data for quarter https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165933#M38075 <HTML><HEAD></HEAD><BODY><P>Awesome ... this works <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /> .. thanks a ton!</P></BODY></HTML> Sat, 30 Oct 2010 19:25:44 GMT https://community.qlik.com/t5/QlikView/Loading-customized-data-for-quarter/m-p/165933#M38075 2010-10-30T19:25:44Z