# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for
Did you mean:
Partner

## Difference between two dates

hello everyone,

I need to findout difference between Completed and alloted date on based of selection of empid.

Status           CreatedDate

Completed     9/2/2016

Alloted           9/23/2016

Thanks

1 Solution

Accepted Solutions
MVP

maybe (it depends on your selection)

max({\$<Status={'Completed'}>} CreatedDate) - max({\$<Status={'Alloted'}>} CreatedDate)

if you have dates, you can use math to find the difference

8 Replies
Specialist II

Interval(if(match(Status,'Completed'),CreatedDate)-

if(match(Status,'Alloted'),CreatedDate),'d')

Partner
Author

What is that 'd' for?

Specialist II
MVP

maybe (it depends on your selection)

max({\$<Status={'Completed'}>} CreatedDate) - max({\$<Status={'Alloted'}>} CreatedDate)

if you have dates, you can use math to find the difference

Partner
Author

Doesnt work

Partner

May be like this :

if Every employee has single date use below one :

Only({<Status={'Alloted'}>}CreatedDate) - Only({<Status={'Completed'}>}CreatedDate)

and

if Every employee has multiple dates use below one :

Max({<Status={'Alloted'}>}CreatedDate) - Max({<Status={'Completed'}>}CreatedDate)

I hope this may helps

-Nagarjun

Not applicable

Try interval(date(Completed,'DD-MM-YYYY')-date(Allotted,'DD-MM-YYYY'),'d').

Here I am assuming that you have two (Completed and Allotted) different fields and you are looking for difference in these dates.

Thanks,

Partner
Author

Thankyou Maxgro ,it worked.

Tags