Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Working with the date YYYY-MM-DD, YYYY ,MM

Hello, I am a new user of QlikView and it's a pleasure join this community.

Working with a field date YYYY-MM-DD I am not able to have a list box with a only row for YYYY and only 12 rows for MM. The only script that I used is the following:

But the script gives me back the following result:

Is there someone who can help me?

Thanks a lot!

1 Solution

Accepted Solutions
Employee
Employee

Re: Working with the date YYYY-MM-DD, YYYY ,MM

use proper functions

Year(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Year,

Month(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Month

7 Replies
Employee
Employee

Re: Working with the date YYYY-MM-DD, YYYY ,MM

use proper functions

Year(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Year,

Month(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Month

Not applicable

Re: Working with the date YYYY-MM-DD, YYYY ,MM

Hi Anjos,

nice to meet you, the solution is perfect.

Thank you so much for your precious support!

Best, Flavio.

kashaboinaraj
Contributor

Re: Working with the date YYYY-MM-DD, YYYY ,MM

Hi

Year(Date#(EVENT_DATE,'YYYY-MM-DD')) as Year,

Month(Date#(EVENT_DATE,'YYYY-MM-DD')) as Month

Regards

vishnu

Re: Working with the date YYYY-MM-DD, YYYY ,MM

One alternative to not having to repeat Date#(EVENT_DATE,'YYYY-MM-DD') would be to use preceding load like this:

LOAD *,

          Year(EVENT_DATE) as Year,

          Month(EVENT_DATE) as Month;

LOAD allyourfields,

          Date#(EVENT_DATE,'YYYY-MM-DD') as EVENT_DATE

Not applicable

Re: Working with the date YYYY-MM-DD, YYYY ,MM

Hi, thanks for your support!

Currently I am working with a date YYYY-MM, but adapting the formula suggested, it doesn't work! Can I have your advice?

Thanks a lot!

Flavio.

kashaboinaraj
Contributor

Re: Working with the date YYYY-MM-DD, YYYY ,MM

Hi Flavio

Please try this

sum(Date#(num(DD-MM-YYYY))

Regards

vishnu

edouard_chandav
New Contributor II

Re: Working with the date YYYY-MM-DD, YYYY ,MM

Working on the sample Thanks a lot. I check on my real model and I close the thread.

Thanks again

Community Browser