topic Month and Year functions in QlikView

Month and Year functions

m4u — Wed, 17 Nov 2010 15:00:25 GMT

hi all,

why when creating a list based on this expression "year(doc_date)" or "month(doc_date)"- selecting one of the values works, but the selected value appears white (not green)?

thanks

shlomo

Month and Year functions

parpatra — Wed, 17 Nov 2010 15:09:18 GMT

i am not 100 % sure...but may be because there is more than one year of data present and there is not one-one relationship,

Month and Year functions

johnw — Thu, 18 Nov 2010 01:21:15 GMT

When you use year(doc_date) as a list box expression, you are selecting all of the individual doc_dates. You can see this if you also have a list box for doc_date, or if you add a current selections object. I strongly suggest creating a calendar table with doc_year, doc_month, and whatever else you might need. Use the real fields from the calendar instead of list box expressions.

Month and Year functions

m4u — Thu, 18 Nov 2010 04:08:38 GMT

Thank you john,

how could i create a calendar table?

shlomo

Month and Year functions

m4u — Thu, 18 Nov 2010 04:10:00 GMT

Thank you john,

how could i create a calendar table?

i'm loading my data from sql-server, i can add those fields to my sql server selection (using sql functions) there is a better way?

shlomo

Month and Year functions

Miguel_Angel_Baeyens — Thu, 18 Nov 2010 09:00:45 GMT

Hello Shlomo,

Use the information and code examples in this post.

Hope this helps.