Help on formulae

[#1]

Dear experts,

I need to make some calculation based on this example:

FechaDMI	5-Ene	7-Ene	12-Ene	13-Ene	18-Ene	22-Ene
	2584	2512	2479	2469	2514	2503

I would like to have an expresion that show the tendency between the last date (22-ENE 2503) and the previous date (18-Ene 2514). As yoy see, the range between dates are diferents, and will always diferent.

I can choose the las date with the MAX(Fecha DMI) but how can I choose a previous date. Thanks in advance for your help, I'm new in QlickView, so you know that any help, tric, tips etc... are well apreciated from the gurus and experts.

Patrick

[#2]

Hi,

First, you'd better transpose your table with 2 fields fecha & value. You can use CrossTable function in the script.

After, you can use Max( Fecha , 2 ) to get the previous date, Max( Fecha , 3) ...

Then it depends of what you want to display. I need more precision of your goal. Why not create a plot with date as dimension & the gap between 2 dates.

Regards

JJ

[#3]

Jean-Jacques,

thanks for your replya, but what I forgot to say is that the values from eadch dates, come from an expresion, there are not a value ina a table. So for each date, all the numbers are the result of an expresion. Hope this is clear.

The goal, is that each time I reload the datas from the databases, I can see the last two dates in a table with there values, and the last column, will be the diference between the last 2 dates.

[boorgura · Accepted solution]

hey Patrick,

if you can get the max date using MAX(Fecha DMI)

then, it is obvious that you have the attribure Fecha DMI, right?

so you can do MAX(Fecha DMI, 2) to the second max date.

Thanks,

Rocky