topic On Open force user to select values in QlikView

On Open force user to select values

Wed, 29 Jun 2011 18:46:07 GMT

Hi,

How can we make qlikview app to force a user to select values for a list box when a particular sheet is activated or when the app is opened.

On Open force user to select values

nagaiank — Wed, 29 Jun 2011 19:27:25 GMT

Instead of tying the need for selection to opening of an application or activating a sheet, you can tie it to display or calculation of an object. For example, if display of values in a table, or bar chart makes sense only when any selection is made (such as display of order detail which requires an oder number, display of YTD value requires selection of year, etc.), you can add the condition for display of the object.

On Open force user to select values

stevedark — Wed, 29 Jun 2011 22:23:27 GMT

What you need to do is create Actions on the appropriate trigger events.

For document open go to Settings \ Document Properties \ Triggers and then select OnOpen and click the Add Action(s) button. Then click the Add button and select Selections \ Select In Field - in the Field box enter the field name and in the Search String box enter the value you want to set. Repeat this step for each field you wish to set.

The search string can contain a fixed value or an expression, for example to select the first item in a field alphabetically you will need to enter:

=minstring(FieldName)

Tabs also have triggers and these are set up in a similar way, right click the background of a sheet and select Properties then the Triggers tab. You can then click Add Actions to enter actions for entering or leaving a sheet.

I tend not to use triggers like this, particularly on sheet changes, as it can confuse the user - but if you have a good reason to do so then the above should help you out.

Good luck,

Steve

Quick Intelligence

Re: On Open force user to select values

Thu, 30 Jun 2011 06:53:46 GMT

Hi,

as krishnamoorthy mentioned you can give conditional calculation, please see the attached sample for the same.