Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Maybe provide an attachment would be helpful for others to solve the problem. Thanks!