topic Re: Employee current status in text box in QlikView

Employee current status in text box

pavan045 — Mon, 08 Feb 2016 11:24:30 GMT

I have a table like this

From this how can I show Employee status on 31/01/2016 in a text box with out using date filter.

sunny_talwar — Mon, 08 Feb 2016 13:41:49 GMT

Try this:

=FirstSortedValue(Status, -EndDate)

swuehl — Mon, 08 Feb 2016 13:57:39 GMT

Maybe the status of EmpId is undefined after 20/09/2015, do you want to show her status then?

You can filter using set analysis:

=FirstSortedValue({<StartDate = {"<='31/01/2016'"}, EndDate = {">='31/01/2016'"}>} Status, -EndDate)

pavan045 — Tue, 09 Feb 2016 06:27:20 GMT

Thank you for your answer sunny...

Your expression gives null values only. I just added 'DISTINCT' and it works.

Final Expression is FirstSortedValue(distinct Status, -EndDate).

Thank you.

pavan045 — Tue, 09 Feb 2016 06:29:47 GMT

Thank you for your answer Swuehl

Please don't bother about EmpId Status after 20/09/2015.

Below expression worked for me.

FirstSortedValue(distinct Status, -EndDate)

Thank you.

sunny_talwar — Tue, 09 Feb 2016 09:54:46 GMT

Awesome, I am glad you were able to figure it out.

Please close the thread if you have got the answer you were looking for by marking correct and helpful answers.

Best,

Sunny