topic Re: Quarter into month in QlikView https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076307#M359054 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution to create three months out of one quarter value could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_211004_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119511_QlikCommunity_Thread_211004_Pic1.JPG" style="height: 376px; width: 620px;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14591145887221883 jive_text_macro" jivemacro_uid="_14591145887221883"> <P>table1:</P> <P>CrossTable (Salesperson, Quota)</P> <P><SPAN>LOAD * FROM [</SPAN><A class="" data-containerid="-1" data-containertype="-1" data-objectid="218416" data-objecttype="13" href="https://community.qlik.com/servlet/JiveServlet/download/2051-211004-1006109-218416/quota.xlsx">https://community.qlik.com/servlet/JiveServlet/download/1006109-218416/quota.xlsx</A><SPAN>] (ooxml, embedded labels, table is Sheet1);</SPAN></P> <P></P> <P>table2:</P> <P>LOAD MonthName(F1,IterNo()-1) as Month,</P> <P>&nbsp;&nbsp;&nbsp; Salesperson,</P> <P>&nbsp;&nbsp;&nbsp; Money(Quota/3) as Quota</P> <P>Resident table1</P> <P>While IterNo()&lt;=3;</P> <P></P> <P>DROP Table table1;</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 27 Mar 2016 21:37:34 GMT MarcoWedel 2016-03-27T21:37:34Z Quarter into month https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076304#M359051 <HTML><HEAD></HEAD><BODY><P>Can anyone tell how to convert quarter quota into montlyquota? I am attaching excel for reference. there is Salesperson id and quarter date with quota.</P></BODY></HTML> Sun, 27 Mar 2016 15:39:40 GMT https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076304#M359051 2016-03-27T15:39:40Z Re: Quarter into month https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076305#M359052 <HTML><HEAD></HEAD><BODY><P>Divide the number by 3.</P></BODY></HTML> Sun, 27 Mar 2016 18:14:45 GMT https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076305#M359052 oknotsen 2016-03-27T18:14:45Z Re: Quarter into month https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076306#M359053 <HTML><HEAD></HEAD><BODY><P class="">Are you looking for a specific output?</P></BODY></HTML> Sun, 27 Mar 2016 20:13:43 GMT https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076306#M359053 sunny_talwar 2016-03-27T20:13:43Z Re: Quarter into month https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076307#M359054 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution to create three months out of one quarter value could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_211004_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119511_QlikCommunity_Thread_211004_Pic1.JPG" style="height: 376px; width: 620px;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14591145887221883 jive_text_macro" jivemacro_uid="_14591145887221883"> <P>table1:</P> <P>CrossTable (Salesperson, Quota)</P> <P><SPAN>LOAD * FROM [</SPAN><A class="" data-containerid="-1" data-containertype="-1" data-objectid="218416" data-objecttype="13" href="https://community.qlik.com/servlet/JiveServlet/download/2051-211004-1006109-218416/quota.xlsx">https://community.qlik.com/servlet/JiveServlet/download/1006109-218416/quota.xlsx</A><SPAN>] (ooxml, embedded labels, table is Sheet1);</SPAN></P> <P></P> <P>table2:</P> <P>LOAD MonthName(F1,IterNo()-1) as Month,</P> <P>&nbsp;&nbsp;&nbsp; Salesperson,</P> <P>&nbsp;&nbsp;&nbsp; Money(Quota/3) as Quota</P> <P>Resident table1</P> <P>While IterNo()&lt;=3;</P> <P></P> <P>DROP Table table1;</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 27 Mar 2016 21:37:34 GMT https://community.qlik.com/t5/QlikView/Quarter-into-month/m-p/1076307#M359054 MarcoWedel 2016-03-27T21:37:34Z