topic Displaying data for last date from the range in QlikView

Displaying data for last date from the range

Mon, 02 Apr 2012 14:30:44 GMT

Hi All,

I have a report where user chooses range of dates on the filter to properly display a bar chart. On the other hand I need to display one value for the last chosen date (max date from the multivalue date filter).

Eg. user selects 12 month to be displayed on the chart - from Jan 2012 to Dec 2012. Apart from the chart, I need to show him in separate text box only the value for Dec 2012.

Any ideas how to do it?

Thanks,

Katie

Displaying data for last date from the range

CELAMBARASAN — Mon, 02 Apr 2012 14:34:26 GMT

Hi,

Check with this

=Sum({<DateField={"=$(=Max(DateField))"}>} Sales) use this type of expression in text box object

Celambarasan

Displaying data for last date from the range

Mon, 02 Apr 2012 14:55:14 GMT

Thanks a lot, that works really perfect!