5 Replies Latest reply: Apr 9, 2012 12:49 PM by luistarzia

# 2 Questions: about filters and view .qvw

Hi everybody.

I see what in expression could filter haw sum,for example

sum({\$<mes={10,11,12}>} valor)

is possible that in an dimension ??

Or i have use if(mes=10 or mes=11) ??

O exists any like "IN" for filter a list or values in a dimension ??

The other question is about view the report  in another machine when i created then with personal edition.

In the other machine i need install the personal edition too ???

Or i have a free server to install ???

• ###### 2 Questions: about filters and view .qvw

For the dimension, you can use the match() function, which works like IN.

=match(mes, 10, 11, 12)

You cannot use a document created with Personal Edition on another machine. It may only be used on the machine that created it. There is no free server option, only priced server.

-Rob

• ###### Re: 2 Questions: about filters and view .qvw

Not working.

if i put =match(mes,10,11,12) in he table show

1

2

3

1 for 10 2 for 11 and 3 for 12

and if i put if(match(mes,10,11,12),'aa','bb') not working

I need a function similar to in because the filter is very long and i not write (if mes=10 or mes=11 or mes =12 etc,

Thanks.

• ###### Re: 2 Questions: about filters and view .qvw

no te late

=If(Mes>=10 and Mes<=12, Mes)

?

• ###### Re: 2 Questions: about filters and view .qvw

El tema es que no son 3 datos,yo puse ese ejemplo pero son unos 20/30 ifs por eso queria saber si hay una especie de IN como pasa en las expresiones con {}

• ###### 2 Questions: about filters and view .qvw

Sorry, I answered too quickly. The dimension expression should be:

=if(match(mes, 10, 11, 12)>0, mes)

-Rob