Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with weekstart function.
I had written a function for date column and it is not working as per my requirement. The formula is
=weekstart(date([Time Full Date],'DD/MM/YYYY'),0,-1)
and it is resulting like below
here for jan,feb,march zero's are not appearing. But I need like
01/18/2015
02/08/2015
pls help me on this one.
Regards,
Kumar
Hi Kumar, you can try this:
Date(weekstart(date([Time Full Date]),0,-1),'MM/DD/YYYY')
Note than the Date() is enclosing the weekstart function, so the date returned by weekstart instead of the default date format will apply the one we specified.
Try this
=weekstart(date([Time Full Date],'MM/DD/YYYY'),0,-1)
How does your data look like?
data is good.
I tried that also.
post your input sample data
Qvd file size is huge. basically I am new to Qlikview. can you tell how to limit no of records in qvd.
Hi Kumar, you can try this:
Date(weekstart(date([Time Full Date]),0,-1),'MM/DD/YYYY')
Note than the Date() is enclosing the weekstart function, so the date returned by weekstart instead of the default date format will apply the one we specified.
Thanks a lot. It resolved my issue.
regards,
Kumar