Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Create a new field

Hi All,

I have a requirement is that,

one field: Emp joined date (MM/DD/YYYY)

Now I want to create a field :

That I should get the count in months i.e. (Today() - (Emp joiined date))

I am using the above mentioned expression, but was unable to get the data. Can any one please help me out in getting the same.

Thanks in advance

1 Solution

Accepted Solutions
dvasseur
Partner
Partner

And this ?

Year(Today())*12+Month(Today()) - (Year([Emp joined date])*12+Month([Emp joined date]))

View solution in original post

4 Replies
MayilVahanan

HI

Try like this

Floor(Today()) - Floor([Emp joined date])  // Its give days not in month..



Thanks & Regards,
Mayil Vahanan R
vardhancse
Specialist III
Specialist III
Author

Hi thanks for your reply/answer,

My requirement is that I want to display in months rather than in days.

Can you please help me out

dvasseur
Partner
Partner

And this ?

Year(Today())*12+Month(Today()) - (Year([Emp joined date])*12+Month([Emp joined date]))

View solution in original post

vardhancse
Specialist III
Specialist III
Author

Hi David,

It was my requirement.

Thanks for your support.