topic FirstSortedValue() with time period in QlikView

FirstSortedValue() with time period

kinjal1645 — Mon, 24 May 2021 11:30:47 GMT

Hi,

Can someone help with the below?

I have the following data:

And below is the expected output:

I used this expression: FirstSortedValue(DISTINCT Rank_type1), -Date_received

But I am only getting the current rank with this expression and also rank_type2 comes blank

Kindly help

Thank you

tresB — Mon, 24 May 2021 12:35:33 GMT

What exact expression are you using for 'Rank_type1 Previous'? Could you share your sample app?

kinjal1645 — Mon, 24 May 2021 16:28:19 GMT

Current

FirstSortedValue(DISTINCT Rank_type1, -Date_received)

FirstSortedValue(DISTINCT Rank_type1, -Date_received, 2)

tresB — Tue, 25 May 2021 05:27:20 GMT

With those expressions I am getting the expected output.

kinjal1645 — Wed, 26 May 2021 10:11:58 GMT

Hi Tresesco,

I am not getting correct output.

I have created a sample file.

Below is the expected output:

Current output:

Would you be able to help?