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

Min date

How can I to load a min date from qvd?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

// from qvd

MinMaxDate:

load

min(Date) as mindate, max(Date) as maxdate from Transactions.qvd (qvd);

// into var

let vMin=peek('mindate');

let vMax=peek('maxdate');

View solution in original post

3 Replies
Not applicable
Author

Same syntax as for any other source

Fabrice

maxgro
MVP
MVP

// from qvd

MinMaxDate:

load

min(Date) as mindate, max(Date) as maxdate from Transactions.qvd (qvd);

// into var

let vMin=peek('mindate');

let vMax=peek('maxdate');

MK_QSL
MVP
MVP

Min(Date) as MinDate