topic Need Help New to qlikview in QlikView

Need Help New to qlikview

Fri, 08 Jun 2012 19:52:54 GMT

Hello everyone,

I need help with my script-I want to view the date as month, year, and day.

Here is my script:

[Event Date],

[Event Type],

Location,

when I write:

Year (Event Date) AS Year,

Month (Event Date) AS Month,

Day (Event Date) AS Day,

it gives me an error. I may be making a small mistake can you write out how i am suppose to write it and exactly where to enter it.

Thank you!

Need Help New to qlikview

deepakk — Fri, 08 Jun 2012 20:30:14 GMT

hi,

You have to put Event Date inside the bracket []

Year ([Event Date]) AS Year,

Month ([Event Date]) AS Month,

Day ([Event Date]) AS Day,

I hope this helps

Deepak

Need Help New to qlikview

Fri, 08 Jun 2012 20:50:50 GMT

Deepak is absolutely correct, any fields with spaces in the name should be referred to with left and right brackets [].

You can also reformat your dates on the numbering tab properties after they've been brought into your QlikView document. For example if you wanted to change MM-DD-YYYY, to just YYYY - this will only render out the year. You can do the same with MM and DD.

-Anthony

Need Help New to qlikview

rwunderlich — Sat, 09 Jun 2012 04:52:33 GMT

Reformatting will not actually group the values, it will just change the display format. If you have two values:

1/1/2012

1/3/2012

Set the format to "YYYY'. Put them in a listbox and you will see 2012 listed twice. Probably not what you want. You have to use the Year() function to extract the year and change the underlying value.

-Rob