Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jbakerstull
Contributor

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
MVP
MVP

Re: Identifying First entry date

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')

9 Replies
MVP
MVP

Re: Identifying First entry date

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
Contributor

Re: Identifying First entry date

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

MVP
MVP

Re: Identifying First entry date

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
Contributor

Re: Identifying First entry date

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

MVP
MVP

Re: Identifying First entry date

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
Contributor

Re: Identifying First entry date

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

MVP
MVP

Re: Identifying First entry date

jbakerstull
Contributor

Re: Identifying First entry date

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?

MVP
MVP

Re: Identifying First entry date

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