Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jbakerstull
Creator
Creator

Identifying First entry date

I'm trying to create a column in a table that would identify the first date within client that have multiple entries.

     This is what the date looks below.

Client IdEntry Exit Provider NameEntry DateExit Date AdjustedTest
758LSS - FM Faith on 6th3/22/20184/5/201820180322
758LSS - FM Faith on 6th4/26/20186/4/201820180426
2134LSS - FM Faith on 6th3/30/20186/15/201820180330
2517LSS - FM Faith on 6th3/9/20185/9/201820180309
4586LSS - FM Nancy's Place2/10/20186/18/201820180210
4587LSS - FM Nancy's Place2/19/20185/4/201820180219
5128LSS - FM Nancy's Place5/19/20186/4/201820180519

My desire result would be:

Client IdEntry Exit Provider NameEntry DateExit Date AdjustedTest
758LSS - FM Faith on 6th3/22/20184/5/2018Fist
758LSS - FM Faith on 6th4/26/20186/4/2018
2134LSS - FM Faith on 6th3/30/20186/15/2018First
2517LSS - FM Faith on 6th3/9/20185/9/2018First
4586LSS - FM Nancy's Place2/10/20186/18/2018First
4586LSS - FM Nancy's Place2/19/20185/4/2018
5128LSS - FM Nancy's Place5/19/20186/4/2018First

I've seen few of examples but I'm still learning the syntax structure of Qlik and it's hard to apply wihtou knowing what thte formula's are doing.

Thanks.

1 Solution

Accepted Solutions
sunny_talwar

So, you need this on the front end of the app? You can try this

If([Entry Date] = Min(TOTAL <[Client Id]> [Entry Date]), 'First')

View solution in original post

9 Replies
sunny_talwar

Try this

Table:

LOAD * INLINE [

    Client Id, Entry Exit Provider Name, Entry Date, Exit Date Adjusted

    758, LSS - FM Faith on 6th, 3/22/2018, 4/5/2018

    758, LSS - FM Faith on 6th, 4/26/2018, 6/4/2018

    2134, LSS - FM Faith on 6th, 3/30/2018, 6/15/2018

    2517, LSS - FM Faith on 6th, 3/9/2018, 5/9/2018

    4586, "LSS - FM Nancy's Place", 2/10/2018, 6/18/2018

    4586, "LSS - FM Nancy's Place", 2/19/2018, 5/4/2018

    5128, "LSS - FM Nancy's Place", 5/19/2018, 6/4/2018

];


Left Join (Table)

LOAD [Client Id],

Min([Entry Date]) as [Entry Date],

'First' as Test

Resident Table

Group By [Client Id];

Capture.PNG

jbakerstull
Creator
Creator
Author

I'm using Qlik Sense, I'm unable to use SQL or load data.

sunny_talwar

Qlik Sense does have a load script, what do you mean when you say that you are able to use load data? You don't have privileges to make script modifications?

jbakerstull
Creator
Creator
Author

correct, I'm working from a 3rd party vendor that slowly switching over to Qlik.  

sunny_talwar

So, you need this on the front end of the app? You can try this

If([Entry Date] = Min(TOTAL <[Client Id]> [Entry Date]), 'First')

jbakerstull
Creator
Creator
Author

Interesting, what does the "total" in the formula accomplish?

jbakerstull
Creator
Creator
Author

Thank you.

Last question, can a formula like "If([Entry Date] = Min(TOTAL <[Client Id]> [Entry Date]), 'First')" be used in an set analysis expression?

sunny_talwar

What exactly is the context? Difficult to know without knowing what you are trying to do...