Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
see my previous, edited post
hope this helps