topic Re: Date in QlikView

Date

Mon, 12 Oct 2015 10:54:47 GMT

Thanks in Advance

Madhu

sujeetsingh — Mon, 12 Oct 2015 11:10:18 GMT

Use make date function and Auto script to create dates

Peter_Cammaert — Mon, 12 Oct 2015 11:12:08 GMT

What is your question?

BTW the NEXT keyword is missing at the end of your script.

Kushal_Chawda — Mon, 12 Oct 2015 11:16:42 GMT

try

let vMinDate = MakeDate(2015,01,01);

LET vMaxdate = MakeDate(2015,01,31);

LOAD date('$(vMinDate)'+IterNo()-1,'DD/MM/YYYY') as Date

AutoGenerate(1)

While '$(vMinDate)'+IterNo()-1 <= '$(vMaxdate)';

tresB — Mon, 12 Oct 2015 11:20:19 GMT

Load

Date(MakeDate(2015,1,RowNo())) as Date

AutoGenerate 31;

Gabriel — Mon, 12 Oct 2015 11:31:09 GMT

Hi,

Try this code

FOR i = 1 TO 30

LET vDate = MakeDate(Year(Today()),$(i),$(i));

Case_Data:

LOAD

MONTH('$(vDate)') AS Case_Month,

DATE('$(vDate)') AS Case_Date

AutoGenerate (1)

;

NEXT i;