topic Re: problem with date in QlikView

problem with date

Anonymous — Mon, 03 Aug 2015 10:17:04 GMT

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

Re: problem with date

qlikmsg4u — Mon, 03 Aug 2015 10:18:59 GMT

Try this

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

Re: problem with date

robert_mika — Mon, 03 Aug 2015 10:36:19 GMT

How does your data look like?

Re: problem with date

Anonymous — Mon, 03 Aug 2015 10:40:40 GMT

data is good.

Re: problem with date

Anonymous — Mon, 03 Aug 2015 10:41:02 GMT

I tried that also.

Re: problem with date

qlikmsg4u — Mon, 03 Aug 2015 10:42:01 GMT

post your input sample data

Re: problem with date

Anonymous — Mon, 03 Aug 2015 10:48:31 GMT

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

Re: problem with date

rubenmarin — Mon, 03 Aug 2015 10:56:17 GMT

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.

Re: problem with date

Anonymous — Mon, 03 Aug 2015 11:02:38 GMT

Thanks a lot. It resolved my issue.

regards,

Kumar