Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

4 Replies
Not applicable
Author

How about :

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


Anonymous
Not applicable
Author

Hi

     Using set analysis you can done this

ex:

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

Regards

Ashok

Not applicable
Author

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
Partner - Champion
Partner - Champion

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