4 Replies Latest reply: Apr 11, 2012 9:17 AM by Celambarasan Adhimulam RSS

    Chart Properties expression in dimension

      Hi,

       

      I am new to qlickview and I have already found a few answers to my questions within these discussions so thank you!

       

      My first question was to only display informatipon which matched 1 criteria, =if(Year(CORPORATEENTRYDATE=2011),AGE).  This worked successfully.

       

      I now need to add 1 more criteria to this expression whcih would be =if(year(TERMINATIONDATE=2011),age).

       

      How do I combine the 2 expressions...?  I am trying but no success.

       

      Thank you for your help.