topic Re: Min date in QlikView

Min date

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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..

Wed, 29 Jun 2016 11:43:55 GMT

Hi Naresh,

You can use group by statement when loading the data.

Regards,

Dila.

amit_saini — Wed, 29 Jun 2016 11:48:02 GMT

Hi,

Better u should only call min dates at script side:

check:

Thanks,

Digvijay_Singh — Wed, 29 Jun 2016 11:52:41 GMT

try like this -

Dimension - Location

Measures -

Firstsortedvalue(date,date)

Firstsortedvalue(<other field>,date)

nareshthavidishetty — Wed, 29 Jun 2016 12:00:49 GMT

Resolved using the below logic..

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

Thanks..

Anil_Babu_Samineni — Wed, 29 Jun 2016 12:38:39 GMT

It's simple

Please Share me your Application?