topic Re: button / macro select expression value in expression/ straight table in QlikView

button / macro select expression value in expression/ straight table

rafael5958 — Sat, 16 Nov 2024 02:02:44 GMT

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?

Re: button / macro select expression value in expression/ straight table

Frank_Hartmann — Mon, 04 Nov 2019 19:52:56 GMT

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

Re: button / macro select expression value in expression/ straight table

rafael5958 — Mon, 04 Nov 2019 19:35:31 GMT

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.

Re: button / macro select expression value in expression/ straight table

Frank_Hartmann — Mon, 04 Nov 2019 19:46:42 GMT

see my previous, edited post

hope this helps