Discussion Board for collaboration on QlikView Scripting.
i'm having issue in date difference
its not showing proper.
Please refer attached application for better understanding
InflowDateNew is a timestamp field, not a pure date so it needs the floor() function to make it true date.
Maybe like this in your expression for pendingdays
Although I would certainly floor() it in the script.
Try this also for getting the day difference in the days
For Test Expression
Aggr((Num(date(Today(),'DD-MMM-YYYY') - Floor(date(InflowDateNew,'DD-MMM-YYYY')), 'DD')), InflowDateNew)