topic Read-only column in Straight Table in QlikView

Read-only column in Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

I am having multiple dimensions for which I want to make as read only .

I am having the expression where I am using the calendar control for getting data between two dates like startdate and enddate and showing aggregation data in the report.

Please suggest how can I implement in my scenario ?

Re: Read-only column in Straight Table

sunny_talwar — Mon, 18 Apr 2016 15:35:27 GMT

May be use set analysis in your expressions to restrict selection in those dimensions where you don't want the selection to impact your dimension

Re: Read-only column in Straight Table

Peter_Cammaert — Mon, 18 Apr 2016 15:40:38 GMT

Do not make those dimensions available in list box format.

Check the ReadOnly option in Straigh Table Properties->General.

Now only the calendar selection objects will control the output in your straight table.

Re: Read-only column in Straight Table

Chanty4u — Mon, 18 Apr 2016 15:53:49 GMT

try this

=If(getselectedcount(Dim)>0)

in expression tab try to create dummy dimension with ur dimension value

lik Dim ,as Dim1

and make it representation as link.. so it will not allow to select