topic Re: conditional show on a container in QlikView

conditional show on a container

dseelam — Mon, 26 Sep 2016 18:15:35 GMT

Hello All,

I have two Charts A&B in a Container, want to activate only chart A when ever I open sheet

thanks,

Dinesh

Message was edited by: Dinesh Reddy Seelam

Re: conditional show on a container

MK9885 — Mon, 26 Sep 2016 19:41:47 GMT

Unlink these charts on Sheet TOM, so that it won;t effect the rest of the charts in other sheet container.

And you can remove the charts B,C,D,E,F and G from your Sheet TOM or Give a conditional expressions for B,C,D,E,F and G.

If you just wanna see Chart A then unlink other charts and remove them from container.

Re: conditional show on a container

dseelam — Mon, 26 Sep 2016 19:44:25 GMT

arvind654

I don't want to get rid of other charts, want to activate chart A first once opened the sheet Tom

Re: conditional show on a container

vishsaggi — Mon, 26 Sep 2016 19:49:55 GMT

Did you try this ?

Select the Chart A in the container and save it and open the file again ?

Try to create a Bookmark and use on activate sheet trigger from sheet properties to activate that bookmark when sheet is opened. ?

Re: conditional show on a container

dseelam — Mon, 26 Sep 2016 19:55:25 GMT

Hello Vish

Select the Chart A in the container and save it and open the file again ?

this is temporary solution I want this chart to be active when ever I open sheet

Try to create a Bookmark and use on activate sheet trigger from sheet properties to activate that bookmark when sheet is opened. ?

don't want any bookmarks

Is there any way we can do this ?

Re: conditional show on a container

MK9885 — Mon, 26 Sep 2016 20:03:26 GMT

What do you mean by Active?

Re: conditional show on a container

vishsaggi — Mon, 26 Sep 2016 20:04:29 GMT

What exactly happening when you trying to open the sheet, using my first option ?

Re: conditional show on a container

vishsaggi — Mon, 26 Sep 2016 20:08:04 GMT

May be try this Macro from this link, as a work around ! By Laura.

How to set a default object to a container ?

Re: conditional show on a container

dseelam — Mon, 26 Sep 2016 20:49:13 GMT

Vish,

I tried Laura technique but dint worked

thanks,

Dinesh

Re: conditional show on a container

vishsaggi — Mon, 26 Sep 2016 21:02:31 GMT

Is it ok to share a sample file if possible ?

Re: conditional show on a container

dseelam — Tue, 27 Sep 2016 13:28:59 GMT

Hi Vish,

I attached a sample to original post as test

Re: conditional show on a container

vishsaggi — Tue, 27 Sep 2016 14:04:37 GMT

It worked for me. Check this file attached? A table box is always highlighted when you come back from an other sheet or close and open the document. Added sheet level and document level trigger here. Let me know if you get stuck.

Re: conditional show on a container

dseelam — Tue, 27 Sep 2016 17:52:11 GMT

Hi Vish,

It worked all I am missing is sheet trigger

Thanks very much for your reply, it's appreciated.