Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

m4u
Contributor II

Month and Year functions

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

Tags (1)
5 Replies
parpatra
New Contributor III

Month and Year functions

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,

MVP
MVP

Month and Year functions

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.

m4u
Contributor II

Month and Year functions

Thank you john,

how could i create a calendar table?

shlomo

m4u
Contributor II

Month and Year functions

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

Hello Shlomo,

Use the information and code examples in this post.

Hope this helps.