Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Min date

Hi ,

My table need to capture only min date data..Below is the table result..

Untitled.png

Here i need to capture only min date for each location(073,094,...) like 073 = 1160521=993=263

Thanks..

1 Solution

Accepted Solutions
nareshthavidishetty
Creator III
Creator III
Author

Resolved using the below logic..

Logic: if (New_A7AIDT= min(New_A7AIDT),New_A7AIDT,min(New_A7AIDT))

Thanks..

View solution in original post

5 Replies
Not applicable

Hi Naresh,

You can use group by statement when loading the data.

Regards,

Dila.

amit_saini
Master III
Master III

Hi,

Better u should only call min dates at script side:

check:

https://community.qlik.com/message/878058#878058

Thanks,

AS

Digvijay_Singh

try like this  -

Dimension - Location

Measures -

Firstsortedvalue(date,date)

Firstsortedvalue(<other field>,date)

Firstsortedvalue(<other field>,date)

nareshthavidishetty
Creator III
Creator III
Author

Resolved using the below logic..

Logic: if (New_A7AIDT= min(New_A7AIDT),New_A7AIDT,min(New_A7AIDT))

Thanks..

Anil_Babu_Samineni

It's simple

Please Share me your Application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful