How to return previous fiscal year in set analysis ?

[Anonymous]

Hello all  ! I am new to Qlikview

I would like to learn to return  values from prior year based on current fiscal year selection.

My fields are :   [FISCAL YEAR]   value : 2015, 2016, 2017

                         [FISCAL QUARTER]  value : Q1, Q2, Q3, Q4

                         Month      value :  Oct - Nov

My Dimension is a stored expression in a variabe : $(vMoney)

My expression is : Num ($(vMoney))

When user selects fiscal year 2017 - how can it return values from 2016 ?

Thanks !

[Digvijay_Singh]

Something like -

Sum({<[FISCAL YEAR]={$(=Max([FISCAL YEAR])-1)}>}$(vMoney))

[Anonymous]

Hi Digvijay

It's not working since the dimension is a variable 

[Digvijay_Singh]

Confusing, I am not able to understand that you have same thing(variable?) as dimension and expression i.e  $(vMoney). What is stored in vMoney variable?

You cannot have expression in the left side of your set analysis condition.

Can you share sample data or app( don't have licesne to open but others may help) to understand further?

[Anonymous]

Hi  Digvijay

Thank you so much for your help !!

vMoney =num( ($(vImpactvsPY)) *(vDivider),MoneyFormat)

I will be able the qvw in 2 hours. Please check back !  I need your help !!

[Digvijay_Singh]

Still not able to understand how your dimension is a variable. vMoney variable stores one expression which has more variables vImpactvsPY,vDivider . Not able to understand the chart dimensions, aggregation measure expressions, if you can share image of ur chart, that would help.