topic Re: How do you make the rows in a straight table non-selectable in QlikView

How do you make the rows in a straight table non-selectable

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

I have a straight table with 4 columns. I would like to choose one of the rows in the table and have the value in one of the columns be used in expressions and graphs on another sheet. The problem is, the users do not want all the rows in the original straight table to disappear. Anyone know of a way to do that?

Re: How do you make the rows in a straight table non-selectable

PrashantSangle — Wed, 06 Jul 2016 07:45:54 GMT

Hi,

did not get your requirement..

If you want to straight table non-selectable then select read only.

Regards

Re: How do you make the rows in a straight table non-selectable

Wed, 06 Jul 2016 08:04:29 GMT

this should be possible by using p or e in your set analysis. Have a look here:

P() & E() and where do you use them?

Re: How do you make the rows in a straight table non-selectable

Wed, 06 Jul 2016 08:15:07 GMT

Using "dimension limit", may be just show 99% of the data, then 1% row cannot be selected. Or, use lock field? Hope it works!

Re: How do you make the rows in a straight table non-selectable

Peter_Cammaert — Wed, 06 Jul 2016 09:29:57 GMT

You want to make selections, and ... not make selections at the same time?

You could accomplish something like that with a selectable copy of your original table that lives in an alternate state together with all the objects on that other sheet.

Peter

Re: How do you make the rows in a straight table non-selectable

antoniotiman — Wed, 06 Jul 2016 09:38:05 GMT

Hi Jim,

in the original Table You can Use Expression with {1} state, like

Sum({1} Value)

Regards,

Antonio

Re: How do you make the rows in a straight table non-selectable

tyagishaila — Wed, 06 Jul 2016 10:16:19 GMT

Hi Jim,

Your problem is not exactly clear to me,

But as I understood,

Write all dimensions clear into your expression.

e.g.

Dimension: Dim1, Dim2, Dim3

Expression: Sum({< Dim1=, Dim2=, Dim3= >}Sales)