topic Field event Trigger in QlikView

Field event Trigger

Tue, 17 Aug 2010 12:52:44 GMT

Hi,

Can anybody help me with my query.?

I have one field (Field 1) with values 'a', 'b', 'c'.

On selection of a or b or c, i want to display one chart and minimize other two. how do i do it through macro.

i know it's pretty simple, but for me, it's some what tough. so, pls help.

Field event Trigger

Tue, 17 Aug 2010 13:10:18 GMT

You need not use macro. You can use an expression in the 'Conditional' show property under the 'Layout' tab. The expression will be as follows:

if([Field 1]='a',true(),false())

If you include above expression in the conditional property of the chart, the chart will be shown only when the value of field 1 is 'a'. You can use similar expression for other charts which should be displayed for other values of Field 1.

Regards, Haneesh

Field event Trigger

Tue, 17 Aug 2010 13:58:59 GMT

Hi you can use this example with "macro" or "hide/show"

But thw macro is not recommended.

Field event Trigger

johnw — Tue, 17 Aug 2010 17:10:05 GMT


Haneesh wrote:if([Field 1]='a',true(),false())

Or just:

[Field 1]='a'