button / macro select expression value in expression/ straight table

[rafael5958]

Hi, I have an straight table like that:

Name	expression
XXXX	3
AAAAA	3
BBBB	2
DDDD	2
SSSS	2
JJJJJJJ	2
QQQQQQQQQ	1
WWWWW	1
EEEEEE	1
RRRRRRR	1

What I need is to create a button or macro to select the expression values higher than 1, so it would reflect in other graphic.

the expression is:

count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID)

How could I do that?

[Frank_Hartmann · Accepted solution]

see attached qvw.

In your real data you need SelectInFieldAction for Field ID

and as search string try this:

='=count({$<TIPO_TITULARIDADE={'&chr(39)&'2-Titularidade diferente'&chr(39)&'},CB-={'&chr(39)&'TAR'&chr(39)&','&chr(39)&'EST'&chr(39)&'},CAD_NOME-={'&chr(39)&'NÃO INFORMADO'&chr(39)&','&chr(39)&'NA'&chr(39)&','&chr(39)&''&chr(39)&',NULL}>} distinct ID)>1'

hope this helps

[rafael5958]

Didt work as expected.

"expression" is not a load field. Its a expression that only exists in the table. Thats why I dont see a way to put an action in a button.

[Frank_Hartmann]

see my previous, edited post

hope this helps