year calculation

[ssriramin19]

Hi everyone,

There are two fields actual sales and actual sales previous year .The date dimension will be always from jan 2015 to dec 2015. One year data will the date dimension.

with respect to actual sales  it will be from jan 2015 to dec 2015..

But for actual sales previous year - need to compute actual sales for period from jan 2014 to dec 2014. So now I have computed individually both actual sales and actual sales last year.

But when displaying under jan 2015 it should be shown as actual sales for jan 2015 and actual sales previous sales for jan 2014.

Please find the image below.Under Jan 2015 it should display actual sales which has data for jan 2015 and also actual sales last year which has data for jan 2014.

How this year needs to be mapped meaning how the jan 2015 for actual sales and actual sales last year .

Please provide some inputs on this.

[ssriramin19]

can any one suggest some technique on how to achieve the above scenario?

[jonathandienst]

I you post your application qvw, or a sample qvw document containing representative data, you are more likely to get useful help with your problem.

[ssriramin19]

the image attached above is the actual requirement for the report.

[jonathandienst]

PNG <> QVW

[ssriramin19]

please suggest some techniques on this to achieve the requirement

[ssriramin19]

I can understand but how to achieve this scenario in qlikview ?