Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fbi
Contributor II
Contributor II

Min(date)

Hello,

I have a date field and in the script is as follows:

Date(Date#([IRLTID],'YYMMDD'),'YYYY-MM-DD') as IRLTID

now I want to get the first date in a table and I tried following solutions but none working:

Min(IRLTID)

Min(Date(Date#(IRLTID,'YYMMDD'),'YYYY-MM-DD'))

Date(Min(IRLTID))

5 Replies
rwunderlich

Are you wanting to get this in the script or in a chart?

-Rob

fbi
Contributor II
Contributor II
Author

in a chart , 

thank you for your reply

rwunderlich

Date(Min(TOTAL IRLTID))

fbi
Contributor II
Contributor II
Author

TOTAL gives me the same value for all rows

 

rwunderlich

Sorry. When you said "first date in a table" I assumed you meant first for the entire table.

-Rob