topic Construct an expression in QlikView

Construct an expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two buttons:

btnA - set expression to period jan-2016 to mar-2016

btnB - set expression to period apr-2015 to jun-2015

Then I have a variable vExpr:

- When btnA, vExpr gets the value 'MonthYear ={">=$(=Date(AddMonths(Min(MonthYear),-$(vMonthDiff)), 'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),-$(vMonthDiff)), 'MMM-YYYY'))"}'

- When btnB, vExpr gets the value 'MonthYear ={">=$(=Date(min(addmonths(MonthYear,-12)),'MMM-YYYY'))<=$(=Date(max(addmonths(MonthYear,-12)),'MMM-YYYY'))"}'

Then I have an expression, in a text object with the following:

='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)'

I'm getting the next result in the text object:

=Money(SUM ({<MonthYear ={">=jan-2016<=mar-2016"}, AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)

When what I really want is the value of the expression above, that should be "90 013 728 €", just for an example.

I think my problem is in the equal signs but I'm not getting there.

Can you please help ?

Thanks in advance,

Sílvia

Re: Construct an expression

sunny_talwar — Mon, 21 Nov 2016 14:28:41 GMT

May be add a dollar sign expansion

$(='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')

Re: Construct an expression

adamdavi3s — Mon, 21 Nov 2016 14:29:18 GMT

Hi Silvia,

I always hit these sorts of problems and it always takes some fiddling to sort out

Does

='Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)'

Not work for you? If not then try

$(='Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')

Re: Construct an expression

Anonymous — Mon, 21 Nov 2016 14:31:51 GMT

Hi Sunny,

Thanks for your help, it worked

I used this:

= $(='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')

Re: Construct an expression

Anonymous — Mon, 21 Nov 2016 14:34:07 GMT

Hi Adam,

Your answer works as well, as long as I put another "=", like in the reply I gave to Sunny.

Thanks too