topic Year and Month in QlikView https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170700#M41010 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have InvoiceDate.SpendDate,InvoiceReceiptDate,InvoicePaymentDate in Single table.</P><P>i want to take Year,Month,Day and week for each fields.</P><P>I taken Year,Month,Day and week from spenddate only. if i select the value year is 2008 it will not show all the values from InvoiceReceiptDate and InvoicePaymentDate. it will show belongs to spenddate. Because i am taken year by spenddate. but i want link with all date fields.</P><P>which 1 is gud, wheather i want to take year by each field by using resident or any other logic???</P><P>looking forward your replies???????????</P><P>-Sathish</P><P></P></BODY></HTML> Sun, 30 May 2010 20:10:21 GMT sathishkumar_go 2010-05-30T20:10:21Z Year and Month https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170700#M41010 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have InvoiceDate.SpendDate,InvoiceReceiptDate,InvoicePaymentDate in Single table.</P><P>i want to take Year,Month,Day and week for each fields.</P><P>I taken Year,Month,Day and week from spenddate only. if i select the value year is 2008 it will not show all the values from InvoiceReceiptDate and InvoicePaymentDate. it will show belongs to spenddate. Because i am taken year by spenddate. but i want link with all date fields.</P><P>which 1 is gud, wheather i want to take year by each field by using resident or any other logic???</P><P>looking forward your replies???????????</P><P>-Sathish</P><P></P></BODY></HTML> Sun, 30 May 2010 20:10:21 GMT https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170700#M41010 sathishkumar_go 2010-05-30T20:10:21Z Year and Month https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170701#M41011 <HTML><HEAD></HEAD><BODY><P>Hi Sathish,</P><P></P><P>I think if you want the selection to filter through to all the other dates as well</P><P>you will have to change the table structure from:</P><P></P><P>InvoiceDate, SpendDate, InvoiceReceiptDate, etc</P><P>1/1/2010, 2/3/2010, 1/3/2010, ....</P><P></P><P>to something like</P><P>DateType, Date, Year, Month etc</P><P>InvoiceDate, 1/1/2010, 2010, Jan...</P><P>SpendDate, 2/3/2010, 2010, Mar...</P><P></P><P>You can do this by concatenating each date field into one table, or using crosstable load.</P><P></P><P></P></BODY></HTML> Mon, 31 May 2010 06:38:48 GMT https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170701#M41011 2010-05-31T06:38:48Z Year and Month https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170702#M41012 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i think Month , and Year , And Day , for one enough why going throug each one /////</P><P></P></BODY></HTML> Mon, 31 May 2010 07:25:38 GMT https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170702#M41012 2010-05-31T07:25:38Z Year and Month https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170703#M41013 <HTML><HEAD></HEAD><BODY><P>Common Calendar would be the solution..</P></BODY></HTML> Mon, 31 May 2010 07:58:30 GMT https://community.qlik.com/t5/QlikView/Year-and-Month/m-p/170703#M41013 2010-05-31T07:58:30Z