Activate Object on Field Selection in Container

gusbus14 — Sat, 16 Nov 2024 21:15:39 GMT

Hello,

I have two straight tables in a QlikView app, Object TABLE1 and TABLE2 (for example). I have these two tables in a container with tabs at the top.

Table 1 contains summary level data, and table 2 contains more detailed data. I would like to be in table 1 and click on an expression value in a column and have it filter based on the dimensions of the table (which it already does) and flip to table 2 within the same container to see the details. I have tried use document properties > triggers with no success. I have read that there are issues with not being able to use actions within a container.

It sounds like I will need to create a macro for this. But I am very new to QlikView and I haven't been able to find code online to create a macro that does this.

Any help is appreciated.

Thanks

Re: Activate Object on Field Selection in Container

bharathadde — Tue, 12 Mar 2019 19:31:10 GMT

Instead of using container try to create two text-boxes or buttons and toggle two charts with triggers on text-boxes or buttons

for suppose on text box 1 triggers --> assign variable=1 and text box 2 triggers --> assign variable=2

then

put condition on layout of TABLE1 like below

=if(variable=1,1,0)

put condition on layout of TABLE2 like below, Fieldname is dimension you mentioned

=if(Getselectedcount(Fieldname)>0 or variable=2,1,0)

Hope this works for you

topic Activate Object on Field Selection in Container in QlikView

Activate Object on Field Selection in Container

Re: Activate Object on Field Selection in Container