Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gino2780
Creator
Creator

generate aggregated date constant

Hello community,

how can i autmatically generate a new (monthly aggregated) date field that is based on an existing date field in a table?

Example:

Date               new date (generated in qlik script)

01.01.2017     01.01.2017

13.01.2017     01.01.2017

22.01.2017     01.01.2017

30.01.2017     01.01.2017

04.02.2017     01.02.2017

07.02.2017     01.02.2017

19.02.2017     01.02.2017

02.03.2017     01.03.2017

14.03.2017     01.03.2017

.                    .    

.                    .

.                    .

etc                etc.

Any suggestions?

1 Solution

Accepted Solutions
prat1507
Specialist
Specialist

Use

Load

Date,

MonthStart(Date) as [new date ]

from

....



Regards

Pratyush

View solution in original post

3 Replies
prat1507
Specialist
Specialist

Use

Load

Date,

MonthStart(Date) as [new date ]

from

....



Regards

Pratyush

gino2780
Creator
Creator
Author

Actually so simple.

Thank you.

prat1507
Specialist
Specialist

Sure. It is!

Regards

Pratyush