No, year is no dimension
I just want to filter the data from the pivot table with year.
ID Animal Count date
1 Cows 200 01/01/2011
2 Sheeps 100 01/01/2012
3 Horses 50 02/01/2012
Now I want to filter the orders of 2012
Now my choice list is like this
But I want to use distinct so the list would be like this
You asked to have the years only, but for presentation purpose.
For Qlikview these values are distinct dates formatted to show only the year. So they look like duplicates, but they are actually seperate values.
Listboxes will only show distinct values.
To avoid this, create a Year filed for the date you want, or you can use as an expression in the list box - Year(date)
(We create at Calender for that purpose.)