Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kumarreddy257
Not applicable

problem with date

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

1 Solution

Accepted Solutions
rubenmarin
Not applicable

Re: problem with date

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.

8 Replies
qlikmsg4u
Not applicable

Re: problem with date

Try this

=weekstart(date([Time Full Date],'MM/DD/YYYY'),0,-1)

robert_mika
Not applicable

Re: problem with date

How does your data look like?

kumarreddy257
Not applicable

Re: problem with date

data is good.

kumarreddy257
Not applicable

Re: problem with date

I tried that also.

qlikmsg4u
Not applicable

Re: problem with date

post your input sample data

kumarreddy257
Not applicable

Re: problem with date

Qvd file size is huge. basically I am new to Qlikview. can you tell how to limit no of records in qvd.

rubenmarin
Not applicable

Re: problem with date

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.

kumarreddy257
Not applicable

Re: problem with date

Thanks a lot. It resolved my issue.

regards,

Kumar