topic multi box show values in QlikView

multi box show values

francis_gr — Thu, 23 Sep 2010 19:40:00 GMT

Hi!

Ì have a multi box that it allows me do selections using 3 fields. One field is año_inicio. Their values are a range between 2005 to 2010.

I would like to show only present and previous year ( 2009 y 2010)

how I can obtain it?

Thanks

Miguel_Angel_Baeyens — Thu, 23 Sep 2010 19:46:52 GMT

Hello,

Go to your multibox and instead of selecting a field from the left list, click on the "Expression >" button, and add something like

=If(año_inicio > 2008, año_inicio)

and label it as you want.

Regards

johnw — Thu, 23 Sep 2010 23:14:46 GMT

I'd base it on the current date so that I didn't have to change my application each year, but same idea:

=if(año_inicio>year(today())-2,año_inicio)

francis_gr — Fri, 24 Sep 2010 10:06:16 GMT

Thanks Miguel!!

That works fine.

thanks

francis_gr — Fri, 24 Sep 2010 10:10:09 GMT

Thanks John!!

Starting off of the idea from Miguel, i have arrived the same expression that you.

Regards