Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load the Min date

Hi,

I have a table :

Date | Call No | status

i want to load the min(date) of a perticular call no where status is 79 or 13...

Can any one help me to write the code for this

i tried this but it is not working

 

LOAD

min(Date) as MDate,

Call_no,

  Status

FROM (ooxml, embedded labels, table is Day1) where status=79 or status=13;

10 Replies
Not applicable
Author

thnks a lot... code worked