topic Conditional View Not Working in QlikView

Conditional View Not Working

Wed, 25 Jan 2012 22:48:57 GMT

In a list box I put this as the expression. The count of lid will always be more than 1 but the listbox never hides. Any ideas?

if(Count (lid) >1,1,0)

Conditional View Not Working

swuehl — Wed, 25 Jan 2012 23:01:41 GMT

You are talking about the conditional SHOW in layout tab, right?

If your condition is true, it will show the object, not hide...

Conditional View Not Working

Wed, 25 Jan 2012 23:10:48 GMT

Yeah I am talking about that show in the layout tab. So I changed it to < and it still did not work.

Conditional View Not Working

swuehl — Wed, 25 Jan 2012 23:24:26 GMT

But if you put 0 or 1 in the expression, it will hide resp. show?

Conditional View Not Working

Thu, 26 Jan 2012 01:21:19 GMT

Sorry I am not sure what you mean. If I put 0 or one where? I can't get it to hide ever. It always shows.

Conditional View Not Working

stabben23 — Thu, 26 Jan 2012 09:22:19 GMT

Hi, Switch position on the 1 and 0 like: if(Count (lid) >1,0,1) or use sum(if(lid)>=1,0,1)) 0 is for hide 1 to show the object.

Re: Conditional View Not Working

swuehl — Thu, 26 Jan 2012 11:47:00 GMT

I am talking about this expresssion. It's just working fine at my place.

If you say, the count is always larger than 1, your condition is like a constant, isn't it? so I assume you do this also for testing?

If I replace

if(count(lid)>1,1,0)

with 1 resp. 0, it's just to test that the Listbox will show resp hide (Or use if(1,1,0) resp. if(0,1,0)).

(And use apply button to apply new conditions, if you hide a listbox and click ok, you need to open sheet properties - objects to be able to enter properties again).

Please check in a textbox, that count(lid) really returns the value you expect.

Conditional View Not Working

Thu, 26 Jan 2012 11:59:20 GMT

Hi,

just go to list box poperties and in layout tab, you will see the show section there you can choose to show always or conditional.

Click on conditional radio button and put 0 there. Just apply and you will see that your list box hides. To show it again put 1 there and click on apply, your list box will appear.

that way you can show and hide.

Now, you just need to put a condiiton here which returns 1 and 0 on the desired condiitons.

...

Ashutosh

Conditional View Not Working

Thu, 26 Jan 2012 17:07:11 GMT

http://screencast.com/t/racxl5Rd4hj I put a 0 in the box but it still won't hide. This is the listbox school id in the screenshot.

Conditional View Not Working

swuehl — Thu, 26 Jan 2012 18:33:26 GMT

Really should work...

Have you tried hiding another object?

And please check

Settings - Document Properties - Security - Show all sheets and objects

is NOT enabled.

Conditional View Not Working

Thu, 26 Jan 2012 20:30:12 GMT

That show all sheets was enabled. That did it