topic Re: Dynamic Year in QlikView

Dynamic Year

Thu, 27 Nov 2014 08:44:04 GMT

Hi all

I'm using this formula to calculate our last year revenue:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {2013}>} Fact.Net_Rev_EUR), '#''##0.00')

As I want to have it dynamic I tried this, but this doesn't work:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = year(today())-1>} Fact.Net_Rev_EUR), '#''##0.00')

I'm sure somebody can tell me why?

thanks for your help

Oliver

tresB — Thu, 27 Nov 2014 08:47:23 GMT

try:

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {'$(=year(today())-1)'}>} Fact.Net_Rev_EUR), '#''##0.00')

its_anandrjs — Thu, 27 Nov 2014 08:48:07 GMT

Try like in SET analysis

Num(sum({<Fact.Type = {'Sales'}, Calendar.Year ={'$(=year(today())-1 )'} >} Fact.Net_Rev_EUR), '#''##0.00')

In set analysis you can't write like

Calendar.Year = year(today())-1

Regards

Anand

jagan — Thu, 27 Nov 2014 08:49:51 GMT

Hi,

Try this

=Num(sum({<Fact.Type = {'Sales'}, Calendar.Year = {$(=Year(Today())-1)}>} Fact.Net_Rev_EUR), '#''##0.00')

Regards,

jagan.