Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do you cancel row from Column

I have a assignment where I don't want the 4 first dates of the column.

expl:

enrollment date (Column)

1/4/2014

1/10/2014

2/6/2014

2/26/2014

4/2/2014

.

.

.my goal is to just keep the 2 last dates of the column..

2 Replies
swuehl
MVP
MVP

Maybe like

LOAD [enrollment date]

FROM YourTableSource

WHERE recno() > 4;

MarcoWedel

LOAD [enrollment date]

FROM yourtable

Where [enrollment date]>'2/26/2014';