topic Re: Age Calculation in QlikView https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391333#M423003 <HTML><HEAD></HEAD><BODY><P>You might be able to use this (with a slight issue)</P><P></P><P><STRONG>Age(Column B, Alt(Column A, Today()))</STRONG></P><P></P><P>The issue is that if in case for a particular selection there is only a single value for Column A, then it will pick Column A even if you have not explicitly selected it. In all other scenarios, this should work the same way as <A href="https://community.qlik.com/people/tresesco">tresesco</A>‌'s solution above.</P></BODY></HTML> Mon, 28 Aug 2017 11:41:26 GMT sunny_talwar 2017-08-28T11:41:26Z Age Calculation https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391331#M423001 <HTML><HEAD></HEAD><BODY><P>Hi I have a date column A. </P><P>I want to write an expression where I am calculating age(Column B-Column A or <SPAN style="font-size: 13.3333px;">Column B-Today()</SPAN> ) by using another column B.</P><P>Now I want to select column A and column B for age calculation if any value is selected from Column A and if no value is selected from column A then today's date should be selected.</P><P><BR />Regards,</P></BODY></HTML> Mon, 28 Aug 2017 05:39:39 GMT https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391331#M423001 rahulsingh12 2017-08-28T05:39:39Z Re: Age Calculation https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391332#M423002 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Age( ColumnB <STRONG>,</STRONG> If( <STRONG>GetSelectedCount</STRONG>(ColumnA)=1, ColumnA, Today()))</P></BODY></HTML> Mon, 28 Aug 2017 05:43:31 GMT https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391332#M423002 tresB 2017-08-28T05:43:31Z Re: Age Calculation https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391333#M423003 <HTML><HEAD></HEAD><BODY><P>You might be able to use this (with a slight issue)</P><P></P><P><STRONG>Age(Column B, Alt(Column A, Today()))</STRONG></P><P></P><P>The issue is that if in case for a particular selection there is only a single value for Column A, then it will pick Column A even if you have not explicitly selected it. In all other scenarios, this should work the same way as <A href="https://community.qlik.com/people/tresesco">tresesco</A>‌'s solution above.</P></BODY></HTML> Mon, 28 Aug 2017 11:41:26 GMT https://community.qlik.com/t5/QlikView/Age-Calculation/m-p/1391333#M423003 sunny_talwar 2017-08-28T11:41:26Z