Chart Properties expression in dimension

[#1]

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.

[#2]

How about :

if(Year(CORPORATEENTRYDATE)=2011 or year(TERMINATIONDATE)=2011,age) ?

[Anonymous]

Hi

     Using set analysis you can done this

ex:

sum( {$<Year = {2011}, Month = {'Jan','Feb','Mar'}>} Sales )

Regards

Ashok

[#4]

Hi, Thank you for your reply.

What you gave me didn't work but I replaced the "or" by "and" and now it work well!

Thank you for putting me on the right track.

[CELAMBARASAN]

Hi,

     You can also do like this

     Sum({<UniqueFieldName={"=(Year(CORPORATEENTRYDATE)=2011 AND Year(TERMINATIONDATE)=2011)"}>} Age )

Unique Field name may be customer Id or employee id like that.

Celambarasan