topic Re: Read a variable in an inline in QlikView

Read a variable in an inline

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Read a variable in an inline

Gysbert_Wassenaar — Sat, 17 Dec 2016 07:56:26 GMT

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

Re: Read a variable in an inline

Anil_Babu_Samineni — Sat, 17 Dec 2016 18:37:24 GMT

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

Re: Read a variable in an inline

Mon, 19 Dec 2016 15:15:49 GMT

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

Re: Read a variable in an inline

Mon, 19 Dec 2016 15:41:41 GMT

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

Thanks.

Re: Read a variable in an inline

marcus_sommer — Mon, 19 Dec 2016 16:17:25 GMT

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