How to make a gauge chart show data from a year before the selected date?

[#1]

Hi!

I have a master calendar. I need a gauge chart to display the data from a year prior to what the user selects. Here is my expression:

=money(sum({<Year ={'$(=Max(Year)-1)'}>}([Total Revenue])))

What am I doing wrong? Thanks for your help, Qlik Community!

[sunny_talwar]

Try it with double qoutes

=Money(Sum({<Year ={"$(=Max(Year)-1)"}>}([Total Revenue])))

[#3]

It shows the same thing. Any other ideas? I really appreciate your help!

[sunny_talwar]

So if your user select 03/24/2015 you want to see a gauge chart for 2014, right?

[satishkurra]

Hi

I tried with sun india expression, it is working fine.

Also try the below by selecting data Year

Sum({$<Year={$(=Only(Year)-1)}>}[Total Revenue])

Thanks

Satish

[awhitfield]

Hi Elizabeth,

if this is not sorted, can you upload an example qvw that shows the issue please?

Andy

[#7 · Accepted solution]

Hey guys,

It is:

=sum({<FiscalYear ={"$(=max(FiscalYear)-1)"}>}NameOfField)

Master calendar has FiscalYear, not just year. That's where is was getting confused. Thanks so much for your help!!!