topic Re: Locking a specific dimension in QlikView

Locking a specific dimension

jamesmf1982 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have put a chart together with a number of dimensions, e.g. employee number, employee name (This is a join from Employee Forename and Surname) and a count of the number of visits they have completed.

As the employee name is a join of two other fields, when I click on the name it puts the forename and surname as two separate selections in the current selections box which is a bit frustrating. I have searched for a way stop the user from clicking on a single dimension and have seen that locking a field is an option. I am not sure how to lock a certain field / dimension down. Can anyone help?

Thanks

James

Re: Locking a specific dimension

Peter_Cammaert — Thu, 14 Sep 2017 12:07:32 GMT

I think the easiest solution to get a ReadOnly dimension column in an object, and just there and nowhere else, is to superimpose a transparent text box (without caption, borders or shadows) over this specific dimension area. That text box should be placed on a hugher layer than the object underneath it. In that way, the text box will capture all mouse clicks and throw them away.

Re: Locking a specific dimension

Clever_Anjos — Thu, 14 Sep 2017 12:17:12 GMT

Is your [Employee Name] a single field

Could you post here your dimension?

Re: Locking a specific dimension

heij1421 — Thu, 14 Sep 2017 12:29:22 GMT

Instead of joining the 2 fields in your application, you can also add it to your load script:

LOAD *,

[Forname] & ' ' & [Surname] as [Employee name]

FROM Employees;

And the use the [Employee name] within your chart

Re: Locking a specific dimension

jamesmf1982 — Thu, 14 Sep 2017 12:37:16 GMT

I have this for the Employee Name

=EmployeeForename & ' ' & EmployeeSurname

Re: Locking a specific dimension

jamesmf1982 — Thu, 14 Sep 2017 12:37:40 GMT

I will give this a go!

Re: Locking a specific dimension

jamesmf1982 — Thu, 14 Sep 2017 12:41:04 GMT

How can I put a read only parameter on the dimension?

Re: Locking a specific dimension

Peter_Cammaert — Thu, 14 Sep 2017 12:50:32 GMT

You can't. The trick I suggested blocks selections in your Calculated Dimension in your table object. Which is an easy one to avoid the selections you described and the creation of new script fields

Re: Locking a specific dimension

jamesmf1982 — Thu, 14 Sep 2017 12:59:48 GMT

Ahh I see what you mean, sorry misread the original message.

Re: Locking a specific dimension

Clever_Anjos — Thu, 14 Sep 2017 13:00:09 GMT

I would concatenate them at script level as heij1421‌ suggested