Variable Input Switch between 6 Months

Loeckli — Wed, 08 Feb 2023 12:05:31 GMT

Hello

I have a graph, which i visualize over the following SET stament:

Max({<ANIMAL={'TIGER'}>*<STATUS={'A'}>*1<SEX={'FEMALE'}>})

I created in date editor the following variable:

SET vTimechanger = 1 ;

I created an variable input, with a drop down list of to 2 fixed items, with the following strings.

last_6months

=if('$(vTimechanger)'=last_6months', DATE_STARTED<=AddMonths(Max(DATE_STARTED), -6))

everything

=if('$(vTimechanger)'=everything', DATE_STARTED))

But my dropdown list seems not work, if either of them are selected the grap still shows all the date values.

What I'm missing ?

topic Variable Input Switch between 6 Months in App Development