Show all rows in a table box regardless of selections

[#1]

Hi

I want to be able to make a single record selection in a tablebox - and have the results of the selection appear in a text box...without the table box also filtering down. That is, I want to be able to always show all records in the table box regardless of the selection made.

I need to do this, as the Table box has input fields, and users need to be able to copy data down to other rows as required. If the selection box always filters on a selection, then they cannot copy data down easily.

Any ideas?

[#2]

We are pushing the boundaries of using QV as a data entry tool... if you check out my comment above, it seems that a Table Box can display images...

[#3]

Jason,

This is a neat trick. I believe I understand the Only function, returning the single value or null. So, how does that stop the table from reflecting the selections?

- Stan

[#4]

Hi Stan

If I may interrupt, it is the use of the set identifier '1' e.g. Only({1} Field4), that prevents the table from filtering.

See Set analysis and set expressions ‒ QlikView

Richard

[Jason_Michaelides]

‌Only() basical returns a value when the is only one possible value. See more here:

The Only Function

What Only() allows is to use other aggregation functionality like set analysis. The {1} in the expression I have used is set analysis syntax to ignore all selections, so Only({1} Field4) shows the Field4 value that links to the other dimension values in the chart, ignoring all selections, but only if there is only one possible value. Ignoring all selections means all values will always show in the chart, even once selections are made.

[vinieme12]

looking at the discussion title I think the requirement was that field selections should not affect the table box and not the other way round!