topic Re: Cannot display texbox using conditional show in QlikView

Cannot display texbox using conditional show

Tue, 26 Feb 2013 12:07:21 GMT

Hello All,

I an having an issue to display a texbox based on a value when using the 'conditional' option. In fact when I test the texbox in a new qvw, the conditional show works perfectly fine but when I try the same conditional expression in my qvw(current application), the texbox doesn't dissapear or appear when I use the 'conditional show'. I find it very strange and I am not able to detect where could be the problem.

Can you please advise where could be the problem?

Thx

Re: Cannot display texbox using conditional show

azimabadi — Tue, 26 Feb 2013 12:09:58 GMT

Hi dallon. can you post your qvw? you can reduce data and post the empty qvw.

Best Regards - Peyman

Re: Cannot display texbox using conditional show

rwunderlich — Tue, 26 Feb 2013 12:43:27 GMT

Try putting your conditional show expression as the expression in a seperate text box to see what it returns.

-Rob

http://robwunderlich.com

Re: Cannot display texbox using conditional show

Thu, 28 Feb 2013 12:11:57 GMT

Hi Peyman,

You will find attached the test qvw where the condition for displaying/hiding the textbox is working fine. When you change sheet, the condtion becomes 0 and qlikview hides the textbox 'testing' and when you click on clear button, the value of the texbox changes to 1 and it makes the texbox 'testing' appear again. When I use the same condition in my application, the condition for displaying/hiding the textbox doesn't work.

Can you please tell me what could be the problem?

Thx

Re: Cannot display texbox using conditional show

Thu, 28 Feb 2013 12:15:37 GMT

Hi Rob,

Can you please tell me what could be the problem?

Thx

Re: Cannot display texbox using conditional show

antose — Thu, 28 Feb 2013 12:49:50 GMT

Have you same Triggers in the other application? “OnActivateSheet” Set Variabel Test to 0

Re: Cannot display texbox using conditional show

Thu, 28 Feb 2013 13:20:02 GMT

Maybe be a bug.

I inserted the same condition when switching from tab to change the value of "Test" variable to 0 and started to function normally.

Try put in your tab "Sheet1" the some trigger used on tab "Main"

After this the parameter "Show" of object was OK

Re: Cannot display texbox using conditional show

azimabadi — Thu, 28 Feb 2013 18:53:28 GMT

Hi dallon,

i mean by example the qvw with problem 🙂

what that i can say at the moment is the layering problem. right click on sheet name and open sheet properties. then find the text box in sheet objects and then qlik on properties. on layout tab of textbox's properties set the layer of textbox to custom and give it a high number like 100. then check the process again. i guess that the text box is under another object and hiden. also check the x and y cordination of it.

-best Regards - Peyman

Re: Cannot display texbox using conditional show

Mon, 04 Mar 2013 09:43:13 GMT

Yes, I have the same trigger in the otjer application

Re: Cannot display texbox using conditional show

Mon, 04 Mar 2013 09:44:59 GMT

Hi,

I have put the same trigger in 'Sheet1' but the problem still persists.

Re: Cannot display texbox using conditional show

Mon, 04 Mar 2013 10:53:03 GMT

Hi Peyman,

I have tried changing the layer values of the textboxes as well but I am still having the same problem:-(

I have attached the qvw which has problem. Can you please check?

Thx

Re: Cannot display texbox using conditional show

jonathandienst — Mon, 04 Mar 2013 11:09:57 GMT

This may be completely off the mark, but have you made sure that the "show all" option is not turned on? You toggle "show all" on and off using Ctrl-Shift S. With "show all" on, conditional display of sheets and object is ignored.

This has fooled me once before when all the objects were displaying and ignoring the conditional display. And the "show all" state seems to get saved with the QV document.

Regards

Jonathan

Re: Cannot display texbox using conditional show

jonathandienst — Mon, 04 Mar 2013 11:12:23 GMT

Following on that, you can also control the "show all" using the "Show All Sheets and Objects" option in the Security tab of the document properties dialog.

Regards

Jonathan

Re: Cannot display texbox using conditional show

Tue, 05 Mar 2013 05:40:00 GMT

Hi Jonathan,

Thanks a lot. The solution you gave me works:-)