Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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?

1 Solution

Accepted Solutions
Highlighted

Hi,

did not get your requirement..

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

6 Replies
Highlighted

Hi,

did not get your requirement..

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Highlighted
Not applicable

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?

Highlighted
Not applicable

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

Highlighted

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

Highlighted
Master III
Master III

Hi Jim,

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

Sum({1} Value)

Regards,

Antonio

Highlighted
Specialist
Specialist

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)