Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.