Min date

[nareshthavidishetty]

Hi ,

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

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

Thanks..

[#2]

Hi Naresh,

You can use group by statement when loading the data.

Regards,

Dila.

[amit_saini]

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 · Accepted solution]

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?