topic Re: Create a new field in QlikView

Create a new field

vardhancse — Wed, 16 Oct 2013 14:20:00 GMT

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

MayilVahanan — Wed, 16 Oct 2013 14:30:34 GMT

Try like this

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

vardhancse — Wed, 16 Oct 2013 14:55:08 GMT

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 — Wed, 16 Oct 2013 15:04:05 GMT

And this ?

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

vardhancse — Wed, 16 Oct 2013 17:37:07 GMT

Hi David,

It was my requirement.

Thanks for your support.