This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
My expression is
if I select Year=2015 then its coming correct, how to get previous year data ie; 2014
Maybe like this:
If not, please post a small qlikview document that demonstrates the problem.
Are you using this in a chart where you have Year or Date as dimension? If yes, then you might need to use Above()/Below() functions to get this to work.
Yes I am using this in a chart (Straight Table), and Date is a dimension.
Date I have linked with master calendar .
You will need to use Above()/Below() function to get it to work. Do you have a sample that you can share?
In Master calendar I have two year field one for fiscal year and other for calendar year.(Fyear(Oct-Sep),Year(Jan-Dec))
I need to calculate FY'15, FY 16 Actuals value.(Two Calculated field).so for Intel division we need to use calendar year(Year) and for others division need to use Mater calendar(Fyear).
if(Division='Intel',sum(value)based on Calendar year,otherwise sum(value) based on fiscal year).
Please help me out in this..sample file is attached.