day & Month with last year and current year comparision

[vikasmahajan]

DEAR ALL,

I WANT TO DISPLAY  OP LIKE THIS

DAY MON       CY              LY

--------------------------------------------------

09/10              12000          500

10/10               15000         600

CURRENT YEAR AND LAST YEAR DATE MONTH & DAY IF SAME SHOULD SHOW IN ONE LINE.

THANKS

BYE

[#2]

Add a PY flag to your script: inyear(AddYears(DATE, 1), $(vToday), 0) * -1 AS PY

I had to do it in another table, since I don't have access to your Excel file, but you can see it in action.

EDIT: Sorry, I misunderstood the issue. The issue is with DayMon. Since you are just formatting the date, QlikView "remembers" that these dates are different, even though the new values look the same. You need to use string concatenation to recreate that field: Num(Day(DATE),'##') & '-' & Num(Month(DATE), '##') As NewDayMon

Fixed the sample file.

[vikasmahajan]

Dear Sir,

Many Thanks Work like Champ.

Regards

Vikas Executive IT