topic Re: Week Format in QlikView

Week Format

abhaysingh — Thu, 30 Apr 2015 14:41:48 GMT

Hello,

i have made one date format with my date i.e. DD/MM/YYYY.

i simply made Dual(week,week) as Week

and when i m doing Today(week) it is giving me M/DD/YYYY format. how i can do in that format DD/MM/YYYY.

and when i m doing today(week) it should give me current week like 14,or 15 etc.

thanks

Re: Week Format

Anonymous — Thu, 30 Apr 2015 14:49:39 GMT

I guess you want week(today()), not the today(week)

Re: Week Format

sunny_talwar — Thu, 30 Apr 2015 14:49:49 GMT

Try Date(Today(week), 'DD/MM/YYYY')
Try Week(Today()) (I guess, from what I am understanding) to get week count. The example will give you 18.

Re: Week Format

buzzy996 — Thu, 30 Apr 2015 16:16:55 GMT

see this,

Re: Week Format

beck_bakytbek — Thu, 30 Apr 2015 22:12:19 GMT

try with week() within of script

Beck

Re: Week Format

MarcoWedel — Thu, 30 Apr 2015 22:50:09 GMT

Hi,

I guess you are looking for the start date of the current week.

If so, then one solution could be;

WeekStart(Today())

hope this helps

regards

Marco

Re: Week Format

ToniKautto — Fri, 01 May 2015 00:33:56 GMT

As a good starting point I would advise on making sure your date format variables are accurately set, with the intended format in your application.

SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss';

The Today() function is expected to return today's date, of the time when the function is called. The format will be according to the format variables.

When working with dates and times I would strongly suggest looking in the "Date and Time functions" section of the Qlik View Help or reference manual. This gives you insight to the available functions and shows simple examples on how they work.

The find the week number I would typically use the Week() function.

Week(MyDate)

Sometimes I want it to have a leading zero for one digit weeks, then I adjust the visual format with the Num() function.

Num(Week(MyDate), '00')

In the examples above MyDate is the field that contains a date value.