Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently our app only displays data from this year and last year .Date starts from 01/01/2013 and ends today 07/16/2014.
Currently I'm filtering the records in the qvd by using the following code
where num(sales_order_date)>=41275;
A:
Load *
from myqvd (qvd)
where num(sales_order_date)>=41275;
How can I dynamically pick the first day of jan last year and use it to filter the qvd
The problem is qlikview treats dates as string
Thanks
B
Now I want to dynamically pick 01/01/2013...next yeatr it should be 01/01/2014...so on instead of hardcoding
date(sales_order_date) = date(yearstart(today()))
Try this
Try like this
let vPrevDate=num(MakeDate((Year(Today())-1),1,1))
vPrevDateCreate the last year Date (Jan 1, 2013) as set in the SET DateFormat=’M/D/YYYY’ .
and then create varible for same as above for current year
let vTodayDate=num(MakeDate((Year(Today())),1,1))
.
vTodayDate created for Date(Jan 1, 2013)