How to calculate Last year Sales

[#1]

Hi All,

I am building a Qlikview App and i have to do TY Sales Vs LY Sales for a month .To calculate LY sales i have created 2 new variables as

vmaxDateIDLY = DateId_LY ( which gives the last year date)

vLY_CurrDate = [Fiscal Year]=, [Fiscal Qtr]=, [Fiscal Half]=, [Fiscal Month]=, [Week End]=,Date=, [Fiscal Week]=, [FiscalWeekDesc]=, DateId={$(vmaxDateIDLY)}

And inside the expression i have something like this

sum({$<$(vLY_CurrDate)>}Sales) .

The output i get is i see a new row in the bottom for the LY date of current date with the sales and remaining all dates as zero's.However if i pick a single date then i get a new row on the top of select date which has last year date and sales .

How do i get the LY sales in the same row rather than getting a new row?

Thanks

[#2]

there is only one date present here, and i cannot open the previous one

[#3]

i think we have TY date was well as LY date so we should be good ?

Thanks

[#4]

im not sure i quite follow you..

But look at this SS. The sales are still the same for the different dates.

[#5]

Hi Thomas,

Do you have any idea of why the sales are same for last year also? Because i do have sales for last year which are different from this year?

Thanks

[#6]

MMaybe because it is reduced data?