topic Get last value from QVD in QlikView

Get last value from QVD

cristian_av — Mon, 28 Jul 2014 15:15:01 GMT

I'm trying to do a incremental reload. FOr that, I need to get the last value from a QVD file (It is ordered from min. first, to max as last record).

This is what I'm doing:

[TEMP_TABLE]:

LOAD CAS_TRANSIT_ID,NAME FROM ..\..\Datos\QVDs\Procesados\Consumos_EBI_Excel_v2.qvd (qvd);

LET vLastValue= PEEK(CAS_TRANSIT_ID,-1,TEMP_TABLE);

But when I see the vLastValue in the variable inspector, it has no value!

What I'm doing wrong?

Thank you!!

Anonymous — Mon, 28 Jul 2014 15:16:53 GMT

Hi you needt to put the expression in '

peek('CAS_TRANSIT_ID',-1,'TEMP_TABLE')

cristian_av — Mon, 28 Jul 2014 15:17:26 GMT

Found it!

I had to use '' in peek. I have no idea why... in somefunctions I don't have to use the ''.

As this:

LET vLastValue= PEEK('CAS_TRANSIT_ID',-1,TEMP_TABLE);