Trellis line chart with a valuelist as Dimension

[schibler]

Hi all,

So, I've a line chart, that have a valuelist as its dimension and aargang (year[time]) as its 2. dimension and one expression.

Valuelist: =ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')

expression: = if(ValueList('uniTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'start', avg({<aargang=,  optaget_1okt={'1'},kvantitativt_reasonnement = {">=0"} >} start_resultat),

if(ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'Kvantitativt', avg({<aargang=, optaget_1okt={'1'},kvantitativt_reasonnement = {">=0"} >} kvantitativt_reasonnement),

if(ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'Kritisk', avg({<aargang=,  optaget_1okt={'1'},kritisk_reasonnement = {">=0"} >} kritisk_reasonnement),

if(ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'Sprogligt', avg({<aargang=,  optaget_1okt={'1'},sprogligt_reasonnement = {">=0"} >} sprogligt_reasonnement),

if(ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'Videnskabeligt', avg({<aargang=,  optaget_1okt={'1'},videnskabeligt_reasonnement = {">=0"} >} videnskabeligt_reasonnement),

if(ValueList('startTEST','Kvantitativt','Kritisk','Sprogligt','Videnskabeligt','Interpersonelt')
= 'Interpersonelt', avg({<aargang=,  optaget_1okt={'1'},interpersonelt_reasonnement = {">=0"} >} interpersonelt_reasonnement),

))))))

My problem is that the "aargang=" in the expressionis not work as it should - meaning if  selecting a year (e.g. 2019), it will show only that year and not the whole timeserie. As showed below

This is what i want as the result (i have not selected year)

any advice?

thanks

schibler

[alex00321]

Hi Maybe provide an attachment would be helpful for others to solve the problem. Thanks!