topic Chart Properties expression in dimension in QlikView

Chart Properties expression in dimension

Wed, 11 Apr 2012 12:27:44 GMT

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.

Wed, 11 Apr 2012 12:44:49 GMT

How about :

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

Anonymous — Wed, 11 Apr 2012 12:52:17 GMT

Using set analysis you can done this

ex:

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

Regards

Ashok

Wed, 11 Apr 2012 13:01:02 GMT

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 — Wed, 11 Apr 2012 13:16:20 GMT

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