how to get data of current year and last year in a single graph with two expression in qlikview

[#1]

how to get sale of current year and last year in a single graph with two expression

i"m using this expresion

current year:=SUM({<FiscalYearName={'$(vCFY)' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

last year:

=SUM({<FiscalYearName={'$(vLFY)' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of Meal]))

[sasikanth]

Hi , try some thing like this

Current Year:

SUM({<FiscalYearName={$(=max(year) },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

Previous Year

SUM({<FiscalYearName={$(=max(year-1) },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

[its_anandrjs]

If you use variables then try with

Let vCFY =Max(Year);

Let vLFY =Max(Year)-1;

Current year:=SUM({<FiscalYearName={'$(vCFY)' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

Last year:

=SUM({<FiscalYearName={'$(vLFY)' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of Meal]))

Or you can use it without variables

Current Yr:=SUM({<FiscalYearName={'$(=Max(Year))' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

Last Yr: =SUM({<FiscalYearName={'$(=Max(Year)-1)' },Flag={'IFK'}  >}_Revenue)/sum(([Total No of Meal]))

[#4]

data is not reflecting by these expression . can you suggest something else???

[#5]

can any1 suggest something please ????

[#6]

please suggest ? i'm stucked.|||||

[sasikanth]

hi

Current Year:

SUM({<FiscalYearName={"$(=max(year)" },Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

Previous Year

SUM({<FiscalYearName={"$(=max(year)-1) "},Flag={'IFK'}  >}_Revenue)/sum(([Total No of SALE]))

check the above and   "  _Revenue" --> this field name is correct or not

or else

share your  .QVW