Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!!!
Try it with double qoutes
=Money(Sum({<Year ={"$(=Max(Year)-1)"}>}([Total Revenue])))
It shows the same thing. Any other ideas? I really appreciate your help!
So if your user select 03/24/2015 you want to see a gauge chart for 2014, right?
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
Hi Elizabeth,
if this is not sorted, can you upload an example qvw that shows the issue please?
Andy
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!!!