Some questions to start.

[#1]

Hello,

I have several questions. I starting on QlikView:

1. I am recover the value of the active selection. This means that if I select a country, it tells me in a text field the country has been selected.

2. How to choose the two years between which you want to do a calculation of evolution? (for a table)

3. Can we retrieve the value of a cell in a table?

Thank you for your answers.

[Anonymous]

1.  You can use Current Selections box.  Other options:

- use text box with function GetCurrentSelections() - for all seelctions

- use text box with function GetFieldSelections(country) - for selections in field "country"

2. There are many ways.  The most natural is just to select all years in the range in a list box.

3. The value of the cell in a table is the value of the table's expression with the selections (or set modifier) matching that cell.  Also macro can be used - but it's better to avoid macros altogether.

[Peter_Cammaert]

• Textbox with expression =concat(Country, ', ')
• Define two variables vCalendarStart and vCalendarEnd and create two Calendar objects that fill those variables. Afterwards you can use those variables in expressions, set analysis etc.
• Not straightaway, except by duplicating the expression with added dimension values in set analysis.

Peter