Clickable and Non-Clickable columns in straight table

Fri, 04 Dec 2009 22:21:57 GMT

I have looked at all the object options but can't seem to figure out how to render certain columns clickable and non-clickable on a straight table ? It's either clickable for all columns or not (selecting the read only option). Is this even possible ?

Thanks.

Clickable and Non-Clickable columns in straight table

wizardo — Sat, 05 Dec 2009 15:34:38 GMT

Hi Anthony,

the only way i could think was to write a macro that will be tied to the "onSelect" event of the field you want to make non-clickable

this macro will contain one line of code:

ActiveDocument.GetField("field name to be made non-clickable").clear

the thing is that by doing so you will cancel selection on this field on all the sheets and objects.

which leads me to the question of what was your original intention.

maybe i didnt get it.

perhaps you ment non-clickable for sort?

i don't think you can disable the sort option on certain columns only, but one thing you could do is to turnoff all sort option for this dimension in the sort "tab".

but then again i don't really see the point in restricting the user on which columns to sort.

can you explain in more details?

Mansyno

topic Clickable and Non-Clickable columns in straight table in QlikView

Clickable and Non-Clickable columns in straight table

Clickable and Non-Clickable columns in straight table