topic Re: Conditional Display Not Working in QlikView

Conditional Display Not Working

jcampbell474 — Wed, 10 Sep 2014 20:41:24 GMT

I have two tables: Dimensions & Metrics. The pivot table will only show when at least one selection is made from both tables. It works perfectly in the QV app. In a browser, however, the entire pivot table appears with every dimension and metric when only one of each are selected. It’s either all or nothing.

I also have a text object to show/hide another text object that has a container in it, to use as filters. I click on the 1^st text object and the 2^nd one shows, but the container does not. In other words, it shows and hides the textbox as designed. The container is nowhere to be found.

In the Pivot Table, here are the settings:

Here is the Calculation Condition (General tab): GetSelectedCount(_idimension) > 0 and GetSelectedCount(_imetrics) > 0

Here is the Selected Dimension Condition: =SubStringCount(Concat(_idimension, '|'), 'Year')

Here is the Selected Expression Condition: =SubStringCount(Concat(_imetricsNo, '|'), 1)

In the layout tab, Conditional is also checked.

Here are the filter settings:

Text Object Button: Actions tab: Value: =if(vFilter=0,1,0)

Text Object to 'hold' container and the container itself: Layout > Conditional > vFilter=1

Identical behavior in both IE and Chrome, with both the IE Plugin and AJAX. Using version 11.20.12347.0 SR6.

Can anyone help me with this? I would really like to have these features.

Re: Conditional Display Not Working

Thu, 11 Sep 2014 06:17:58 GMT

Jason,

I guess for the next time it would be very helpful if you'd attach your document.

Is it possible you checked the 'Show All Sheets and Objects' in Settings --> Document Properties --> Security tab ?

This option makes Qlikview ignore the conditional show of objects.

See the attached picture.

If this doesn't help, please attach your document.

Best regards!

Moritz

Re: Conditional Display Not Working

jonathandienst — Thu, 11 Sep 2014 06:23:49 GMT

Jason Campbell wrote:

I also have a text object to show/hide another text object that has a container in it, to use as filters. I click on the 1^st text object and the 2^nd one shows, but the container does not. In other words, it shows and hides the textbox as designed. The container is nowhere to be found.

A textbox cannot have a container "in" it. If you placed a container on top of the textbox, that does not result in a relationship between them. Perhaps I misunderstood you.

Is the container hidden behind the text box? Adjust the layer of each item in the Properties | Layout tab. Higher layers will appear on top of lower layers.

Jonathan

Re: Conditional Display Not Working

jcampbell474 — Thu, 11 Sep 2014 15:00:54 GMT

My apologies, having a container 'in' a text box was my description of its appearance, not the actual structure. There is no relationship between them whatsoever, except for their placement of above/below the other on the screen.

The container is hidden above the text box. The text box layer is -2, the container, 4. It works perfect in the app, during development. Just doesn't function correctly when in a browser.

Re: Conditional Display Not Working

jcampbell474 — Thu, 11 Sep 2014 15:13:14 GMT

The selection you described is unchecked. The items are layered properly and it works perfectly in development. Just doesn't work in Chrome and IE.

Re: Conditional Display Not Working

jcampbell474 — Fri, 19 Sep 2014 15:35:47 GMT

I attached a sample of what I'm trying to do. It works in the app, but not in Chrome...or IE w/the plugin.

Can anyone tell me why the text object will hide/un-hide, but the container will not?

Re: Re: Conditional Display Not Working

jcampbell474 — Fri, 19 Sep 2014 17:10:27 GMT

Moritz, thank you. Here is an example of what I'm trying to do.

Re: Re: Conditional Display Not Working

Mon, 22 Sep 2014 05:53:55 GMT

Hi Jason,

I tested your file.

It worked fine.

I tried in Mozilla Firefox & IE...

I can't imagine why it isn't working in your place...

Have a nice day!

Moritz

Re: Re: Conditional Display Not Working

jcampbell474 — Mon, 22 Sep 2014 12:23:14 GMT

Thank you for checking, Moritz. Did both the Text Object TX827 and Container CT07 appear for you? The Text Object is all that appears for me.

Re: Re: Conditional Display Not Working

Mon, 22 Sep 2014 12:44:58 GMT

Yes, I checked again...

Might it be possible that the Textbox is on the wrong level?

What I mean is that the Textbox is on top of the Container & the container gets concealed by the Textbox...

Is this possible?

Re: Re: Conditional Display Not Working

jcampbell474 — Mon, 22 Sep 2014 13:51:41 GMT

Anything in possible 🙂

The text object is layer -2 and the container is simply "Top". So, you're saying that both 'objects' show for you?

Re: Re: Conditional Display Not Working

Mon, 22 Sep 2014 13:57:50 GMT

Yes, thats true

Yes, everything shows just fine...

Tested it in IE and Firefox...

Re: Re: Conditional Display Not Working

jcampbell474 — Tue, 23 Sep 2014 18:51:32 GMT

Moritz, I was finally able to push the test file out to the server, then test in my browsers. It's still only showing me the text object...container is nowhere to be found. Tried it in IE9 and Chrome.

Can you post a screenshot of one of the browsers showing both? Any idea's why they show them, but mine doesn't?

Thanks!

Re: Re: Conditional Display Not Working

Wed, 24 Sep 2014 05:34:35 GMT

Good Morning

See the attached picture.

I've separated all objects, maybe try this too...

I actually have no idea why it doesn't work for you

Is updating IE an option?

Re: Conditional Display Not Working

Thu, 27 Aug 2015 03:43:16 GMT

Hi, I'm sure you've resolved this issue by now, but someone else may encounter it. I certainly just had the same problem! We overcame it by changing the default viewer from full browser to IE Plugin.

This following is an excerpt from Brent Nichol. Found in this thread. (How to change Ajax to IE Plug-in)

...

The default path for AccessPoint is configured in QEMC > System > Setup > QlikView Web Servers > QVSW > AccessPoint. If you have a different web page that you want to use, this where to change it.

Also, if you want IE Plug-in as the default, you can change the Default Preferred Client on the same screen.

Hope this helps,

How to change Ajax to IE Plug-in

Re: Conditional Display Not Working

neha_sri — Thu, 14 Jul 2016 19:14:02 GMT

Hi,

I am also facing the same issue, but the above suggestion is also not working for me.

Could you suggest

Re: Conditional Display Not Working

neha_sri — Thu, 14 Jul 2016 19:24:53 GMT

Hi Jason,

Did you get the fix to this issue. I am also facing the same issue.

Thanks

Re: Conditional Display Not Working

jcampbell474 — Fri, 15 Jul 2016 11:55:20 GMT

This was a couple of years ago and I don't recall a specific fix. I haven't had the same issue since then, but I've stayed away from containers - try to use list or multiboxes instead (usually reserved for filters). I also develop solely for compatibility in ajex (vs ie plugin).

Sorry that I don't have a solution.

Re: Conditional Display Not Working

neha_sri — Fri, 15 Jul 2016 13:48:47 GMT

Thanks

Re: Conditional Display Not Working

Sakura — Mon, 01 Oct 2018 22:02:08 GMT

Faced the similar issue today. Container object in Qlikview makes it messy! layout conditional show or hide was not working in Webview but in Desktop version it was perfect! Spent like hours understanding the issue!

Hate Containers! I am never going to use it again!