Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Dear Sir,
Many Thanks Work like Champ.
Regards
Vikas Executive IT