topic Clicking on Expression column applies selection in QlikView

Clicking on Expression column applies selection

Thu, 13 Mar 2014 03:33:33 GMT

Let's say I have a straight table that has 3 dimensions and 3 expressions. (One of the expressions is an Inputfield which may or may not affect my case.)

Symptom: When I click on the input box, if I do not click close enough to the right of the box it actually applies a selection rather than entering the input field. Is there any way to disable this, or somehow make it easier to enter into the input field without applying a selection?

Re: Clicking on Expression column applies selection

sujeetsingh — Thu, 13 Mar 2014 03:36:41 GMT

I dont think any such setting is there .

Re: Clicking on Expression column applies selection

Fri, 02 Oct 2015 04:16:59 GMT

The reason for this is indeed related to the column being a InputField. Basically what's happening is when you click on the cell (of the InputField) you are applying a selection to the table to filter for rows with that InputField value. This can be confusing when you first create your InputField and your values are likely all blank.

Not a great work around, but how I've done this in the past is to place a transparent text box on top of the table which is nearly the width of the input field, and the full height of the table.This allows the user to click that TINY little blue arrow to go into the InputField without accidentally applying a filter. This is not perfect since you still have to deal with an additional object floating on top of the table, plus there are still tiny slivers of a few pixels on each row where a user could actually still click and apply a filter.