topic 2 sliders for the same fields in QlikView

2 sliders for the same fields

Fri, 07 Jun 2013 13:32:42 GMT

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

Re: 2 sliders for the same fields

alexandros17 — Fri, 07 Jun 2013 13:47:13 GMT

for the second slider use an expression as field:

if(year>=2009 and year<=2012, year, null())

Re: 2 sliders for the same fields

Wed, 12 Jun 2013 08:26:32 GMT

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)

=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 ?