topic Is there a way to lock a sheet when "clear all" is pressed in QlikView

Is there a way to lock a sheet when "clear all" is pressed

Fri, 02 Mar 2012 17:24:45 GMT

I am really new to qlikview and want to know if there is a way to lock one sheet/tab if the clear all button is pressed. There is one sheet that we have that will pull up too much data if it is activated and no criteria has been selected while on another sheet. Would like to be able to lock one sheet after clear all is set and unlock it once criteria is entered. Possible?

Is there a way to lock a sheet when "clear all" is pressed

Fri, 02 Mar 2012 17:48:00 GMT

One thing you could try as an alternative to locking/unlocking based on conditionals:

You can right click on the object/(s) that display way too much data if it is activated, click on properties. Click on the layout tab, and on the right hand side in about the middle under show, click on conditional. Then enter in the criteria for when you want for the object to be shown. When the criteria is not met, it will not display at all.

Is there a way to lock a sheet when "clear all" is pressed

erichshiino — Fri, 02 Mar 2012 20:30:49 GMT

Hi,

When the users has no selection, the function getCurrentSelections() will return null.

So, in the show condition of the sheet ( Sheet Properties -> General tab -> Show sheet, you can write:

where

=len(getcurrentSelections())> 0

but this condition may not be as robust as you need it.

You can make a count in a field to determine if it is appropriate to calculate your object. (e.g., count( INVOICE_ID))

Then, you condition would be:

= count(INVOICE_ID) < 100000

Instead of the show condition, in a chart you can create a calculation condition:

Chart Properties -> General Tab -> Calculation condition.

The advantage is that you can set a message (same tab-> error messages -> Calculation condition unfulfilled) where you can put something like: "Please, make some selection...'" etc

Hope this helps,

Erich

Is there a way to lock a sheet when "clear all" is pressed

Fri, 02 Mar 2012 21:15:28 GMT

thanks, both the suggestions are very helpful but this second one is what I was looking for. Thank you!