topic select second last date in QlikView

select second last date

Tue, 24 May 2016 06:27:07 GMT

hello.

i have a table with 2 fields: donation place, donation_last_date.

the last date field works ok.

the problem is when a donation was cancelled it still shows me the last donation date and i would like to show only the last donation date for a donation that was not cancelled. it could be the second max date or the third.

place	donation_last_date
A	25/05/2015
B	01/06/2016
C	12/10/2015
D	09/08/2014

now if donation A and B were cancelled i would like to show the previews donation date that was not cancelled

thanks

for donation A i have those dates:

25/05/2015 -cancelled

22/04/2015 -cancelled

10/04/2015 -donation done

Re: select second last date

CELAMBARASAN — Tue, 24 May 2016 07:08:22 GMT

How will you decide the donation is cancelled? based on which field, since you have only 2 fields.

try if you have status field

Max({<status-={'Cancelled'}>} Donation_last_date)

Re: select second last date

Kushal_Chawda — Tue, 24 May 2016 07:13:13 GMT

If you just want to select second last date then

=max(Donation_last_date,2)

Re: select second last date

Chanty4u — Tue, 24 May 2016 07:31:18 GMT

=Firststoredvalue(Donation_last_date,-2)

Re: select second last date

Tue, 24 May 2016 07:42:58 GMT

STRIAGHT TABLE

with place as dimension

Max({<status={'donation done''}>} Donation_last_date)

Re: select second last date

avinashelite — Tue, 24 May 2016 07:44:15 GMT

try like this

=max({your set analysis condition }Donation_last_date,2)

Re: select second last date

Tue, 24 May 2016 07:46:44 GMT

i do have a field

it does not work. it still shows me only the last donation

Re: select second last date

Tue, 24 May 2016 07:47:04 GMT

it does not work. it still shows me only the last donation

Re: select second last date

Tue, 24 May 2016 07:50:18 GMT

it does not work. it still shows me only the last donation

Re: select second last date

Tue, 24 May 2016 08:48:23 GMT

if you do not have a field , then how we will verify that donation has been done or not.

We need to have some indicator to check the donation status.

Re: select second last date

Tue, 24 May 2016 09:55:52 GMT

i have a field called donation_status

Re: select second last date

Anonymous — Tue, 24 May 2016 14:39:56 GMT

Hi,

If you do have a field, what's it called ? Can you upload your qvw file ?