Read a variable in an inline

[#1]

Hi

I have the following problem.

In a simple table expression I am reading a variable that in turn reads a field generated in inline.

The expression generated by the inline is as follows:

Expression1: sum ({<Year = {'$ (vLastYear)'}>} Sales)

Then I generate a variable that is equal to "Expression1" and that variable places it in a straight table. It returns me a good result but without considering the previous year, I consider the current year.

Thank you

[Gysbert_Wassenaar]

I don't understand the question. Can you post a small qlikview document that explains what you want?

[Anil_Babu_Samineni]

Hi, Try like below from script level. this is as i assume

1) LET vLastYear = Max(Year)-1;

2) LET vFinal = sum ({<Year = {'$ (vLastYear)'}>} Sales)

Then use =$(vFinal) and use text object then see

[#4]

Hello

Thanks for answering.

I leave you a file with my problem. Thanks for the help.

The problem is that "Sales 2" does not display the same as "Sales 1". This is because when you read a variable in an inline, it does not read it.

The tables must show the same result

Thank you

[#5]

Thanks for the answer But it does not serve me what you indicate.

Thanks.

[marcus_sommer]

Take a look on these examples:

Central KPI Formula Repository (solution)

Storing variables outside of QlikView

Loading Variables Via Loadscript

Managing Variables

Re: Setting a variable in script...

How to store and recover variables

Create Colour Variables from an Excel Workbook

- Marcus