topic Disable Selection feature on fileds in QlikView

Disable Selection feature on fileds

Thu, 21 Jan 2010 15:54:12 GMT

Hello,

I have an InputField where users can enter values. The table containing this Field is an Inline table having 10 rows and empty values for the InputField.

The InputField is presented in a Table object.

My problem is that when i click on a value of the InputField, Qlikview filters the field and display only one line. So I want QV to prevent users from making selections in this field and only be able to input values. I have been able to do it using macros on the Select Event (clear selection when user make a selection) but I don't like it because it disrupts the use of Back and Forward buttons.

Thank You for your help....

Disable Selection feature on fileds

Wed, 01 Dec 2010 17:54:55 GMT

did you find a way how to disable the user selection on fields?

I find one way to disable userselction for a particular field is to use set anaylsis e.g.

disable user selection for Actual Month

=only({1}[Actual Mth])

Im interested on how you approached this using a macro to prevent user selection. Can you send me more details how i can add this or an example would be great.

Many thanks

Disable Selection feature on fileds

Thu, 02 Dec 2010 04:10:47 GMT

maybe =only({1<Company=>}[Actual Mth]) is better

Disable Selection feature on fileds

Thu, 02 Dec 2010 04:15:27 GMT

=only({$<Company=>}[Actual Mth])

Disable Selection feature on fileds

Thu, 02 Dec 2010 08:46:30 GMT

I finally ended using this piece of code to do it. It's not the most safe way to do it, but i expect people using the "Clear" option of the select lists instead of messing with the Active Selection and start to Unlock fields manually.

ActiveDocument.Fields("G1").Unlock
ActiveDocument.Fields("G1").SelectAll
ActiveDocument.Fields("G1").Lock

(G1 is the Inputfield)

The macro is currently started when opening the document, Maybe i will move it to the activation of the sheet presenting inputfields.

Thanks.

Disable Selection feature on fileds

Thu, 02 Dec 2010 12:57:48 GMT

Hi do you know if i can use this method to disregard user selection in my pivot table (see screenshot below).

Basically the only selection i want the user to use is the Month/Year list box. At the moment when a user clicks any particular field in the pivot it performs filtering (WHICH I DONT WANT).

I want the pivot to stay the same all the time but just use the Month/Year user list filter.

Any ideas?