Filter of Range for weekname

[qvhjenvo]

Hi,

I want to make a plot for course of Dollars vs Norwegian for last year based on week or weekname.

=avg({$<to_currency = {'USD'}, currency_weekname = {"(='>=' & WeekName(Addyears(max(date(Date#(currency_date, 'YYYYMMDD'))),-1)) & '<=' & WeekName(Addyears(max(date(Date#(currency_date, 'YYYYMMDD'))),0)) )"}>}(1/currency_exchange_factor) * currency_unit)

Somebody give me hints why this expression does not work.

Thanks in advandce

Regards

Loi

[Digvijay_Singh]

Don't have access to qvw, can you share what output you are getting, also you can use expression as label of Straight table column to see where it is getting wrong to refine further.

[qvhjenvo]

Wear that u do not have access to qvw. I seems that my filter

currency_weekname = {"(='>=' & WeekName(Addyears(max(date(Date#(currency_date, 'YYYYMMDD'))),-1)) & '<=' & WeekName(Addyears(max(date(Date#(currency_date, 'YYYYMMDD'))),0)) )"}

does not work.

I am trying to attche qvw agian. But I how to do it.

Loi

[tamilarasu]

Hi Loi,

Try this expression,

=avg({$<to_currency = {'USD'}, currency_weekname = {$(=concat(distinct chr(39) & currency_weekname & chr(39), ','))}>}(1/currency_exchange_factor) * currency_unit)