topic age function displaying age, month in QlikView https://community.qlik.com/t5/QlikView/age-function-displaying-age-month/m-p/234720#M86053 <HTML><HEAD></HEAD><BODY><P>Hi Chris, you can use the date function. Like.. Month (Date) as month and then add into the dimension on the chart (simple table in this case) with this function you will see a new column called month.</P><P>Best...</P></BODY></HTML> Tue, 01 Mar 2011 16:12:11 GMT pgalvezt 2011-03-01T16:12:11Z age function displaying age, month https://community.qlik.com/t5/QlikView/age-function-displaying-age-month/m-p/234719#M86052 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>we are currently using Cognos but are evaluating moving to Qlickview. Within Cognos there is an age function that allows the age and month to be displayed in a report similar to below:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 458pt; border-collapse: collapse;" width="609"><COLGROUP><COL style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;" width="147" /><COL style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;" width="154" /><COL style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;" width="140" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70" /></COLGROUP><TBODY><TR height="21" style="height: 16.35pt; mso-height-source: userset;"><TD class="xl22" height="21" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black 0.5pt solid; width: 110pt; border-bottom: #d4d0c8; height: 16.35pt; background-color: white;" width="147">Customer Operations</TD><TD class="xl23" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black; width: 116pt; border-bottom: black 0.5pt solid; background-color: white;" width="154">Customer Services</TD><TD class="xl23" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black; width: 105pt; border-bottom: black 0.5pt solid; background-color: white;" width="140"></TD><TD class="xl23" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black; width: 74pt; border-bottom: black 0.5pt solid; background-color: white;" width="98">63yrs 1mths</TD><TD class="xl24" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black; width: 53pt; border-bottom: black 0.5pt solid; background-color: white;" width="70">63</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>i can't see where i can display the month as can only see references to age in years. any help would be mush appreciated</P><P></P><P>Regards</P><P></P><P>Chris</P></BODY></HTML> Tue, 01 Mar 2011 15:50:57 GMT https://community.qlik.com/t5/QlikView/age-function-displaying-age-month/m-p/234719#M86052 2011-03-01T15:50:57Z age function displaying age, month https://community.qlik.com/t5/QlikView/age-function-displaying-age-month/m-p/234720#M86053 <HTML><HEAD></HEAD><BODY><P>Hi Chris, you can use the date function. Like.. Month (Date) as month and then add into the dimension on the chart (simple table in this case) with this function you will see a new column called month.</P><P>Best...</P></BODY></HTML> Tue, 01 Mar 2011 16:12:11 GMT https://community.qlik.com/t5/QlikView/age-function-displaying-age-month/m-p/234720#M86053 pgalvezt 2011-03-01T16:12:11Z