topic Re: How to save latest selection in QlikView

How to save latest selection

marco_puccetti — Mon, 13 Apr 2015 14:12:16 GMT

Hello, I need to save in a variable the value of the latest selection (year) for the computation of a sum on a previous year.

Anybody knows how to do this?

Thanks

Marco

Re: How to save latest selection

marcus_sommer — Mon, 13 Apr 2015 14:17:03 GMT

You could use max() for this directly within the expression:

sum({< year = {"$(=max(year))"}>} value)

vs.

sum({< year = {"$(=max(year)-1)"}>} value)

- Marcus

Re: How to save latest selection

Anonymous — Mon, 13 Apr 2015 15:19:07 GMT

you could do what Marcus suggested and not use variable at all. but if you want to create variables for other purposes, then create variables using Ctrl+Alt+V and click on Add.

1. vMaxYear and expression will be =max(year)

2. vPrevYear and expression as = max(year) -1