Discussion Board for collaboration on QlikView Scripting.
How to get the yesterday value from date field
count(orders) for yesterday(11/27) is some x amount how to get this?
Hope it helps u
You will get Yesterday date by subtracting 1 from todays date.
yesterdayDate = Today() -1
Internally the date is stored as number.
In expression you can use like this
Hope this helps you.
you can use
LET Vyesterday = today()-1;
i tried the above conditions its not working it shows null
order date is the date field
need to calculate the yesterday count(order) for order date.
Did you tried this
If it not works then check where there is any Date format mismatch.