topic date in QlikView

date

srinivasa1 — Fri, 07 Oct 2011 09:40:20 GMT

we need to from todays date generetaet 12 month date and year .pls help me

date

srinivasa1 — Fri, 07 Oct 2011 09:42:38 GMT

we need to from todays date need generetaet last 12 month date and year .pls help me

date

kaushiknsolanki — Fri, 07 Oct 2011 09:48:01 GMT

Hi,

Do you mean you want to create a master calander from last 12 months till now.?

If yes then try following code.

Let vMin = num(Makedate(2011,01,01));

Let vMax = num(today());

Temp:

Load

Date($(vMin) + Iterno() -1) as Date

Autogenerate 1

While Date($(vMin)) + Iterno() -1 <= $(vMax);

MasterCal:

Load Date,

Month(Date) as month,

Year(Date) as Year

Resident Temp;

Drop table Temp;

Regards,

Kaushik Solanki

date

srinivasa1 — Fri, 07 Oct 2011 09:58:06 GMT

hey i think it will help full to me. i need qurter also in this can you pls guide me.will get back to you about ur ans.

date

kaushiknsolanki — Fri, 07 Oct 2011 10:04:36 GMT

Hi,

add this.

'Q' & Ceil(Month(Date)/3) & '/' & Year(Date) AS Qurter

Regards,

Kaushik Solanki

date

srinivasa1 — Mon, 10 Oct 2011 07:04:37 GMT

wow !!!! it is working thx Kaushik......bit bussy last week..not able to reply..

date

kaushiknsolanki — Mon, 10 Oct 2011 07:09:23 GMT

Hi,

Glad to help..

Regards,

Kaushik Solanki

Re: date

dseelam — Fri, 24 Jan 2014 18:35:21 GMT

Hi Kaushik,

The below statement working perfectly alright but does the past 12 months will be changing daily once the script is reloaded ?

Let vMin = num(Makedate(2011,01,01));

Let vMax = num(today());

Temp:

Load

Date($(vMin) + Iterno() -1) as Date

Autogenerate 1

While Date($(vMin)) + Iterno() -1 <= $(vMax);

MasterCal:

Load Date,

Month(Date) as month,

Year(Date) as Year

Resident Temp;

Drop table Temp;