topic Re: Peek date? in QlikView

Peek date?

johnan — Mon, 09 Mar 2020 13:36:24 GMT

Hi,

I have at table with dates.

I want to only have the next post after :
Where Date= Today() + Next day

2020-03-13 (I want 2020-03-13 and 2020-03-16)
2020-03-16 (I want 2020-03-16 and 2020-03-17)
2020-03-17 (I want 2020-03-17 and 2020-03-20)
2020-03-20

I forgot, but i think peek?

digichap28 — Tue, 10 Mar 2020 19:32:42 GMT

I would first order the table, later use peek to get the previous date and finally reorder it using ASC.

1)Loading the data

2020-03-13
2020-03-16
2020-03-17
2020-03-20

2) Ordering DESC

2020-03-20
2020-03-17
2020-03-16
2020-03-13

3) Using PEEK

2020-03-20
2020-03-17 - 2020-03-20
2020-03-16 - 2020-03-17
2020-03-13 - 2020-03-16

4) Ordering ASC

2020-03-13 - 2020-03-16
2020-03-16 - 2020-03-17
2020-03-17 - 2020-03-20
2020-03-20

I hope you get the idea

Best regards

johnan — Tue, 17 Mar 2020 08:45:02 GMT

Yes, thanx mate 🙂