Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Something like -
Sum({<[FISCAL YEAR]={$(=Max([FISCAL YEAR])-1)}>}$(vMoney))
Hi Digvijay
It's not working since the dimension is a variable
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?
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 !!
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.