Using Variables for Expressions

NZ_QV_Guy — Fri, 03 May 2019 04:22:26 GMT

Stuck on this one for some time today, hoping some more brains can help figure it out.

For ease of example I have two variables:

"vFormula_1001" which looks like: Sum({<DateFilter,[GL Account Group]={'A*'}>} ActValue)

and "vFormula_1002" which looks like: Sum({<DateFilter,[GL Account Group]={'B*'}>} ActValue)

I then have a table chart with 1 Dimension: ValueList('Row1','Row2'), and 12 columns: "Fiscal Month 1", "Fiscal Month 2" … etc. through "Fiscal Month 12".

What I want to do is replace the "DateFilter" text portion of the variables with "FiscalMonth={'01'}", 02 … etc. through 12 and evaluate the resulting string as my expression.

So my chart expression for Fiscal Month 1 is: pick(RowNo(),Replace(vFormula_1001, 'DateFilter,', 'FiscYear={'&Chr(39)&'01'&Chr(39)&'}'),Replace(vFormula_1002, 'DateFilter,', 'FiscYear={'&Chr(39)&'01'&Chr(39)&'}')).

In this form the expression evaluates perfectly, displaying as a string. However as soon as I put a $() or $(=) around each pick option I get no results.

Reason I am doing this is to build some financial reports and I don't want to have to duplicate by 12 each line as a variable.

Re: Using Variables for Expressions

jaibau1993 — Fri, 03 May 2019 07:25:40 GMT

Hi!

You only need two new parametriced variables. Please, check the attached file.

Bests,

Jaime.

topic Using Variables for Expressions in QlikView

Using Variables for Expressions

Re: Using Variables for Expressions