Fetch second last record from date column.

rupaliqlik — Tue, 06 Jun 2023 12:25:09 GMT

Hi Team,

I have a data set where I have one date column and other is patient id.User want to show second last date in report.

I used previous function but it is not working fine.Kindly help me.

Below is my code

[SR Infusion Temp]:
LOAD
[Patient ID] ,
[SR Infusion DOT],
Peek([SR Infusion DOT],-1) as _commondate
Resident [SR Infusion]
order by [Patient ID],[SR Infusion DOT] ASC;
DROP Table [SR Infusion];
RENAME Table [SR Infusion Temp] to [SR Infusion];

@abhijitnalekar ,sunny_talwar ,Kaushik Solanki

Re: Fetch second last record from date column.

a_mullick — Wed, 07 Jun 2023 15:58:18 GMT

Hi,

See if this helps.

I've put in a set analysis solution and an alternative scripted solution, but basically you should be able to do what you want using the FirstSortevalue() function.

topic Fetch second last record from date column. in QlikView

Fetch second last record from date column.

Re: Fetch second last record from date column.