Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a sheet ages are divided into classes. I want to apply on these classes 2 sliders, one that allows you to see what the age curve is on eg 3 years and the other slider which the age curve will be at about eg 15 year.
What do I need to do to make this happen. The chart is ok when I use 1 slider, but how to provide the second one.
Thanks
for the second slider use an expression as field:
=
if(year>=2009 and year<=2012, year, null())
Thanks for your answer but perhaps some more info.
The chart with 1 slider, works correct with Demension
=class(age(MakeDate(Year(Now(1)), 12,31),dateofbirth) + if(Expression='Future', vAddToAge, 0), 5, age between', 0)
For the second slider I have copied Expression='Future' to Future2 and vAddToLeeftijd to vAddToAge2
At least I copied Dimension
=class(age(MakeDate(Year(Now(1)), 12,31),dateofbirth) + if(Expression='Future', vAddToAge, 0), 5, 'age between', 0)
to
=class(age(MakeDate(Year(Now(1)), 12,31),dateofbirth) + if(Expression='Future2', vAddToAge2, 0), 5, 'age between', 0)
At that moment the line of the first Dimension disappeared en the second dimension become the legend.
What do I Wrong ?