topic Last Value Date Dolar in QlikView

Last Value Date Dolar

pgalvezt — Fri, 21 Aug 2015 19:47:49 GMT

Hi,

I have a table with values obtains in web.

Can you help me to obtain the last value in the Fields Mes and Día.

Here is the link if you have questions:

I need the value on 20th aug

Tomorrow on 21th aug and so on.

Thanks!! !

swuehl — Fri, 21 Aug 2015 20:27:50 GMT

You need to create a date from Mes and Dia, so you can use the Date field in FirstSortedValue.

See attached.

pgalvezt — Fri, 21 Aug 2015 20:43:22 GMT

Thanks!

In 2016 Do I have to create the same code (2016) and concatenate?

RESULT:

LOAD *, Date#('2016-'&Mes&'-'&Día,'YYYY-MMM-D') as Date

Resident INPUT;

DROP TABLE INPUT;

swuehl — Fri, 21 Aug 2015 20:50:04 GMT

You probably just want the value for today, right?

So you can use

RESULT:

LOAD *, Date#(Year(today())-'&Mes&'-'&Día,'YYYY-MMM-D') as Date

Resident INPUT;

DROP TABLE INPUT;

If you need to keep historic data, a concatenation would only make sense for the latest date value on each new day, right?

pgalvezt — Mon, 24 Aug 2015 14:24:47 GMT

Right,

by the way:

RESULT:

LOAD *, Date#(Year(today())-'&Mes&'-'&Día,'YYYY-MMM-D') as Date

Resident INPUT;

DROP TABLE INPUT;

I pasted this code but doesn´t work.

swuehl — Mon, 24 Aug 2015 17:53:21 GMT

Yes, there is a typo in the calculated field:

RESULT:

LOAD *, Date#(year(today())&'-'&Mes&'-'&Día,'YYYY-MMM-D') as Date

Resident INPUT;