topic Re: Active Sheet in QlikView

Active Sheet

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

If i clik on one chart it should go to a diffierent sheet,can any one help hoe to achive ths

Re: Active Sheet

cristianozilz — Tue, 27 Mar 2018 11:27:36 GMT

Hi, Vignesh S

Look if this example help You.

In the Object Propriets, go to action and add the Activate Sheet.

Re: Active Sheet

vignesh_s — Tue, 27 Mar 2018 11:39:26 GMT

hi thanks for reply, i have pivot table if i clik on that it should go to different sheet nd presert sheet should disable

Re: Active Sheet

thevingo — Tue, 27 Mar 2018 11:51:50 GMT

1. you can put a transparent textbox with Action to Activate Sheet

2. or you can put a small icon/button/text for that & name it 'Click for Details' for user to understand

To hide the sheet, you can add another action as to Set a Variable & use that variable to conditional show/hide your sheet (Sheet Properties>General tab> Show Sheet>Conditional

Re: Active Sheet

cristianozilz — Tue, 27 Mar 2018 11:57:27 GMT

I don't know if this is possible,

But you can hide the sheet. and control all movimentation with text objects.

Re: Active Sheet

el_aprendiz111 — Tue, 27 Mar 2018 20:13:12 GMT

1 exmp:

Re: Active Sheet

Anonymous — Tue, 27 Mar 2018 21:34:14 GMT

Try insert one object Text (Hide) with action on top of the graphic object.

Transparent Text Object in Properties/Trigger you bild a action ....