Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about :
if(Year(CORPORATEENTRYDATE)=2011 or year(TERMINATIONDATE)=2011,age) ?
Hi
Using set analysis you can done this
ex:
sum( {$<Year = {2011}, Month = {'Jan','Feb','Mar'}>} Sales )
Regards
Ashok
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.
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