2 Questions: about filters and view .qvw

[#1]

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

Thnaks in advance.

[rwunderlich]

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

[#3]

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.

[#4]

no te late

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

?

[#5]

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 {}

[rwunderlich · Accepted solution]

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

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

-Rob