topic Re: last value in QlikView

last value

Tue, 19 Jul 2011 10:14:32 GMT

Hi,

I have the following data and was wondering what is the best approach to collect the last value...

value, date

1532.00, 29/01/2010

1560.00,31/01/2010

1590.00,17/9/2010

1420.00,30/12/2010

1500.00, 29/01/2011

1300.00,31/01/2011

1990.00,17/9/2011

110.00,30/12/2011

what I am looking for, is while doing the chart, and in case the year selected ... then I should show the values related to last value of each year, and if months selected then the same thing to show the last value of each month ....

any help

Re: last value

sparur — Tue, 19 Jul 2011 10:55:42 GMT

Hello,

I think, that the most simple way it's:

- create a variable, for example, with name vMaxDate and with definition: =Date(max(TransDate), 'DD/MM/YYYY').

- create a Set Analysis expression with this variable.

for more details, please see in my small example in attachment.

last value

Tue, 19 Jul 2011 11:17:35 GMT

many thanks Sparur,

I have set earlier the same , but my issue is that if I select the 2 years (2010 & 2011) I should be able to see the last value of each year in the chart .... in your example, I can only see one selection at a time

Re: last value

sparur — Tue, 19 Jul 2011 11:47:08 GMT

if you select 2 values of year you get the last value for max year.

Is it ok for you?

last value

Tue, 19 Jul 2011 11:54:15 GMT

nop, if I select the 2 values, I need to see the value of each year (i.e. 2 records in the sheet) ... currently I see the last value of 2011....

Re: last value

sparur — Tue, 19 Jul 2011 12:12:51 GMT

ok, I'm understand now.

may be you can create a new table with group by statement in the script:

last value

Thu, 04 Aug 2011 06:23:25 GMT

Thanks, that works for me ... but I noticed the layout used in the list box is not available for me.... is it a theme that I should download ....