Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
use proper functions
Year(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Year,
Month(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Month
use proper functions
Year(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Year,
Month(Date#(EVENT_DATE,'YYYY-MM-DD')) AS Month
Hi Anjos,
nice to meet you, the solution is perfect.
Thank you so much for your precious support!
Best, Flavio.
Hi
Year(Date#(EVENT_DATE,'YYYY-MM-DD')) as Year,
Month(Date#(EVENT_DATE,'YYYY-MM-DD')) as Month
Regards
vishnu
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
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.
Hi Flavio
Please try this
sum(Date#(num(DD-MM-YYYY))
Regards
vishnu
Working on the sample Thanks a lot. I check on my real model and I close the thread.
Thanks again