topic Re: generating date for every value in a table in QlikView https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629719#M476495 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>create a calendar table wich every year-month you need&nbsp; and join it with your product table</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Tue, 27 May 2014 15:44:42 GMT 2014-05-27T15:44:42Z generating date for every value in a table https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629718#M476494 <HTML><HEAD></HEAD><BODY><P>hi guys </P><P></P><P>I have a table which has products for example</P><P>Product</P><P>A</P><P>B</P><P></P><P>I want the output table as follows:</P><P>Product MonthYear</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 2014</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb 2014</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar 2014</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr 2014</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 2014</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb 2014</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar 2014</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr 2014</P><P></P><P></P><P></P><P></P><P>Please help</P></BODY></HTML> Tue, 27 May 2014 15:38:51 GMT https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629718#M476494 2014-05-27T15:38:51Z Re: generating date for every value in a table https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629719#M476495 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>create a calendar table wich every year-month you need&nbsp; and join it with your product table</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Tue, 27 May 2014 15:44:42 GMT https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629719#M476495 2014-05-27T15:44:42Z Re: generating date for every value in a table https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629720#M476496 <HTML><HEAD></HEAD><BODY><P>Products:</P><P>load * inline [</P><P>Product</P><P>A</P><P>B</P><P>];</P><P></P><P>t:</P><P>load</P><P>&nbsp; date(makedate(2014) + rowno()-1) as d</P><P>AutoGenerate 365;</P><P></P><P>Months: </P><P>load </P><P>&nbsp; distinct</P><P>&nbsp; capitalize(date(MonthStart(d), 'MMM YYYY')) as Month</P><P>resident t</P><P>Where month(d) &lt;= 4</P><P>;</P><P></P><P>drop table t;</P><P></P><P>join (Products)</P><P>load * Resident Months;</P><P></P><P>DROP Table Months;</P></BODY></HTML> Tue, 27 May 2014 15:49:23 GMT https://community.qlik.com/t5/QlikView/generating-date-for-every-value-in-a-table/m-p/629720#M476496 maxgro 2014-05-27T15:49:23Z