topic Re: help with expression in QlikView

help with expression

arusanah — Thu, 02 Jul 2015 14:03:48 GMT

I have a variable vFromDate, which i use to calculate current year sales.

i haanother Variable vPYFromDate which i am using to calculate prev years sale

vPYFromDate = 'AddYears(vFromDate,-1)'

i'm trying to write an expression but doesn't work

=SuM({$<TimeLine.Year={$(vPYFromDate)}>}(Fact.CustomerSales*$(=CurrencyField)))

throws error in set modifier

pls help!!

Anonymous — Thu, 02 Jul 2015 14:06:25 GMT

try

=Sum({$<TimeLine.Year={"$(vPYFromDate)"}>}(Fact.CustomerSales*$(=CurrencyField)))

Regards!

Jannet.

alexandros17 — Thu, 02 Jul 2015 14:08:33 GMT

try with

SuM({$<TimeLine.Year={$(vPYFromDate)}>}(Fact.CustomerSales*$(CurrencyField)))

Peter_Cammaert — Thu, 02 Jul 2015 14:21:21 GMT

Since apparently vPYFromDate contains an expression to evaluate first, you'll have to do just that to get a real date value:

=SuM({$<TimeLine.Year={"$(=$(vPYFromDate))"}>}(Fact.CustomerSales*$(=CurrencyField)))

although this may not work either as TimeLine.Year may now be compared to a single full date value...