topic Get last loaded value by date in QlikView

Get last loaded value by date

Sun, 27 Mar 2011 20:11:35 GMT

Hello All, in QV I load different article prices in different time periods. Example;

In QV this is loaded as below;

What i want to do is in a QV Pivot table get the Min article price over YTD 2010, this I do as follows;

For reporting over period 2010-07

MIN (if (InYearToDate (TreatmentDate,'31-07-2010',[Price]))

And over 2010-05

MIN (if (InYearToDate (TreatmentDate,'31-05-2010',[Price]))

But I also want to get the last known price;

When reporting over period 2010-07, i want the result;

And reporting over 2010-05, I want the result

Can anyone help me out here?

Thanks in advance!

Get last loaded value by date

Mon, 28 Mar 2011 06:04:37 GMT

Can anyone help me out here please, I'm stuck.

Get last loaded value by date

Mon, 28 Mar 2011 06:11:36 GMT

Hi,

please see the attached example (Script).

Good luck!

Rainer

Get last loaded value by date

Mon, 28 Mar 2011 06:32:31 GMT

This is a solution if you only want to see it for 1 date. But if you want to have selection possibilities for the date it is not working anymore

Get last loaded value by date

Mon, 28 Mar 2011 08:06:40 GMT

anyone else another hint?

Get last loaded value by date

Wed, 30 Mar 2011 08:14:49 GMT

I tried this with

FirstSortedValue(Price,-TreatmentDate)

I think it should be something like this, but above isn,t working yet. anyone a hint?

Get last loaded value by date

Thu, 31 Mar 2011 10:50:12 GMT

Above is working now!!. I looked at aggregated level first, then the function runs into multiple values and it doesn't return anything, but if you go to n-level it is working fine