topic Re: firstsortedvalue in QlikView

firstsortedvalue

manoranjan_d — Mon, 03 Oct 2016 10:28:44 GMT

Hi all,

Instead of firstsortedvlue there is any other way to get the max date of the key?

Re: firstsortedvalue

qlikview979 — Mon, 03 Oct 2016 10:43:16 GMT

try this

Product

Max(Fieldname) as maxdate

from Source

---------- Group by Product;

Note: after group by write all fields.

Regards

Mahesh

Re: firstsortedvalue

qlikview979 — Mon, 03 Oct 2016 11:03:01 GMT

Hi Try this

T1:

LOAD

PRODUCT,

SALES,

DATE

FROM

New Microsoft Excel Worksheet.xlsx]

(ooxml, embedded labels, table is Sheet1) ;

let Vpeek=peek('DATE',0,'T1');

Regards,

Mahesh

Re: firstsortedvalue

Anonymous — Mon, 03 Oct 2016 11:21:23 GMT

Hello Manoranjan

May be this helps you:

Table1:

Load ID, date from source;

Table2: Load max (date) as maxdate;

Resident Table1;

Let MAXDATE= peek('maxdate',0,Table2 );

Thanks & Regards

Chintan Gala

Re: firstsortedvalue

maxgro — Mon, 03 Oct 2016 11:22:46 GMT

Another option could be

load * inline [

key, date

1, 01/01/2016

1, 01/01/2015

1, 01/01/2014

2, 01/02/2010

2, 01/02/2016

3, 01/03/2016

];

// join order by key and date desc,

// keep only the first key (max date)

left join (S)

load key, date as maxdate

Resident S

where key <> Peek('key')

order by key, date desc;

Re: firstsortedvalue

Mon, 03 Oct 2016 12:03:51 GMT

Hi,

pls try this, parameter vMD will be filled with the highest date presuming that date is a daynumber (like 40365)

//Determine highest Date
MD: NoConcatenate
LOAD Max(Date) as MD;
LOAD FieldValue('Date', recno()) as Date
AUTOGENERATE FieldValueCount('Date');

let vMD = peek('MD',0,'MD');

good luck!

HtH

Re: firstsortedvalue

Tue, 04 Oct 2016 05:39:01 GMT

Hi Chintan,

the fieldvalue way is much more performant especially with large tables.

Try is out and you will see.

Cheers