Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

making dates

hi,

In my Master Calendar I have

  Year(TempDate) As Year

This displays as :-

but when I create a variable for Current Year it displays like this?:-

why does vYear_Current not show as a year?

Labels (1)
10 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Your expression for the variable is correct, so there is no need to change anything there. The values of vYear_current in the list box were not produced by that expression as they are dates, whereas the expression returns just the year number.

There is some confusion though - you cannot show a variable (which has a single value) in a list box. So it seems you have a variable vYear_current AND a field named vYear_current and the list box is displaying the field values. There is no relationship between the variable vYear_current and the field vYear_current.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein