topic Re: Date Functions in QlikView

Date Functions

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

This is my Calendar....

I want to create one field WeekNumber (start should be 1,2,3,4,5,6)

Let vMinDate=Num(MakeDate(2015,01,01));

Let vMaxDate=Num(MonthEnd(Today()));

Load

$(vMinDate) AS Date,

week($(vMinDate)) As Week,

Year($(vMinDate)) As Year,

Month($(vMinDate)) As Month,

Day($(vMinDate)) As Day,

Week(weekstart($(vMinDate))) & '-' & WeekYear($(vMinDate)) as WeekYear,

WeekDay($(vMinDate)) as WeekDay

Autogenerate (1)

While ($(vMinDate)+IterNo())<$(vMaxDate);

Actually i have created weeknumber, but year=2016 and Month=Feb.. it showing starts from 2,3,4,5,6

But my requirement.. it should be 1, 2,3, 4, 5

Whatever if i am click any month it should start from 1,2,3,4,5,6

Thanks in Advance.....

Re: Date Functions

sunny_talwar — Thu, 03 Mar 2016 15:08:33 GMT

Seems like a dynamic functionality you are looking for on the front end of the application. If that's true then there is nothing in the script you can do which would help you with this requirement. You will need to figure out a way to do it on the front end of the application.

Re: Date Functions

Gabriel — Thu, 03 Mar 2016 15:10:37 GMT

Hi,

For your week Number why not try

Num(week($(vMinDate))) As WeekNumber,

Re: Date Functions

Nagaraju_KCS — Thu, 03 Mar 2016 15:16:09 GMT

Yes, i want show front end.

Back end also not a problem.

If i am click 2016 and Feb..... I want show WeekNumber starting with 1....so on

Re: Date Functions

sunny_talwar — Thu, 03 Mar 2016 15:23:21 GMT

Do you have a sample you can share?

Re: Date Functions

Nagaraju_KCS — Thu, 03 Mar 2016 15:31:09 GMT

General Calendar 2005 to 2016

Please copy this code......

Let vMinDate=Num(MakeDate(2015,01,01));

Let vMaxDate=Num(MonthEnd(Today()));

Load Date($(vMinDate)) AS Date,

week($(vMinDate)+IterNo()) As Week,

Year($(vMinDate)+IterNo()) As Year,

Month($(vMinDate)+IterNo()) As Month,

Day($(vMinDate)+IterNo()) As Day

AutoGenerate 1 while $(vMinDate)+IterNo()<$(vMaxDate);

Thanks....

Re: Date Functions

Gabriel — Thu, 03 Mar 2016 15:38:23 GMT

Try

Num(WeekDay($(vMinDate)+IterNo())) AS WeekNumber.

This will start from zero (0)

Re: Date Functions

bohravanraj — Thu, 03 Mar 2016 15:43:23 GMT

Please Refer Attach Qvw.

i hope it will solve your Purpose

Regards.

Re: Date Functions

Joaquin_Lazaro — Thu, 03 Mar 2016 15:44:03 GMT

Hello Qv_Testing

Please, read this links

Redefining the Week Start

Redefining the Week Numbers

Hope it helps you

Joaquín

Re: Date Functions

Nagaraju_KCS — Thu, 10 Mar 2016 14:31:32 GMT

HI Vanaraj,

This is perfect all right..

My Application very huge. It's taking much reloading time...

is there any way to implement Script level.....??

Re: Date Functions

Nagaraju_KCS — Fri, 11 Mar 2016 07:36:19 GMT

Please anyone can help me....

Re: Date Functions

Fri, 11 Mar 2016 07:58:15 GMT

Add this at the top to your script an make sure det dateformat is the same:

SET DateFormat='YYYY.MM.DD';

SET vCal_FD = 0; // First Day of the week {0=Mon, 1=Tue, ... , 6=Sun}
SET vCal_BW = 1; // Broken Weeks allowed {0=No, 1=Yes}
SET vCal_RD = 4; // Reference day = This day in Jan defines week one {1..7}

//and this in the tabelscript that you are uploading

Div( your date field here - WeekStart( Date( YearStart( If( $(vCal_BW), your date field here, Date( WeekStart( your date field here, 1, $(vCal_FD) ) - $(vCal_RD) ) )) + $(vCal_RD) - 1), 0, $(vCal_FD) ) + 7, 7 ) as Week,

Year( Date( YearStart( If( $(vCal_BW), your date field here , Date( WeekStart(your date field here , 1, $(vCal_FD) ) - $(vCal_RD) ) )) + $(vCal_RD) - 1) ) as Year,

Month( Date( MonthStart( If( $(vCal_BW), your date field here , Date( WeekStart( your date field here , 1, $(vCal_FD) ) - $(vCal_RD) ) )) + $(vCal_RD) - 1) ) as Month,