topic Expression in a Button referencing any Table in QlikView

Expression in a Button referencing any Table

leonardo_alexsa — Thu, 08 Mar 2018 19:43:30 GMT

Hi Guys,

This is my second post here.

I would like a little help to see it's possible...

I have a Straight Table that calculate a ABC CURVE of the products. There is a column with this words "A", "B", or "C". I need to resume how many are.

This quantity I want to show in a button.

See this example:

Is it possible ?

Re: Expression in a Button referencing any Table

jwjackso — Thu, 08 Mar 2018 20:19:14 GMT

If there a really only those 3 items:

='A = '&Count({$<CURVA={'A'}>}CURVA)&Chr(10)&'B = '&Count({$<CURVA={'B'}>}CURVA)&Chr(10)&'C = '&Count({$<CURVA={'C'}>}CURVA)

Why a button and not a text object?

Re: Expression in a Button referencing any Table

leonardo_alexsa — Fri, 09 Mar 2018 18:12:04 GMT

Sorry, it's is in a text object*

This expression doesn't work. Because "CURVA" is an expression in a Straight Table, that is the mistake.

I need to resume that expression out of the Straight Table using a Text Object.