topic Re: Show all rows in a table box regardless of selections in QlikView

Show all rows in a table box regardless of selections

Fri, 09 Sep 2016 06:21:49 GMT

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?

Re: Show all rows in a table box regardless of selections

sunny_talwar — Fri, 09 Sep 2016 23:47:58 GMT

May be using alternate state:

Qlikview-Alternate States Fundamental-Inheritted vs Default

Re: Show all rows in a table box regardless of selections

vinieme12 — Sat, 10 Sep 2016 12:35:55 GMT

If you don't want to apply any selection, detach the table!

Re: Show all rows in a table box regardless of selections

ToniKautto — Sat, 10 Sep 2016 12:47:41 GMT

Tablebox object will not allow that. Instead use a straight table chart. Add an expression that shows your desired values, preferrably this is done by using a set expression. If you do not want the expression visible, simply hide it from Chart Properties > Presentation

Re: Show all rows in a table box regardless of selections

ToniKautto — Sat, 10 Sep 2016 12:49:37 GMT

I do not think the selection in a detached table will reflect in an other object, so how do you imagine that will resolve the requirement?

Re: Show all rows in a table box regardless of selections

Jason_Michaelides — Sat, 10 Sep 2016 18:05:34 GMT

See attached - hope it helps.

Basically do as Toni says and use a straight table and have at least one field as an expression, using set analysis to ignore all selections. In my example, Field1, Field2 and Field3 are all dimensions. Field4 is in the expression Only({1} Field4). This will still allow selections to be made in the table, but the table won't reflect this.

Jason

Re: Show all rows in a table box regardless of selections

Tue, 13 Sep 2016 23:24:19 GMT

The challenge is that the only entries available for inputfields in straight tables are numeric. I need to enter text.

Re: Show all rows in a table box regardless of selections

Tue, 13 Sep 2016 23:41:41 GMT

The other alternative is whether I can show images in a table box...

Re: Show all rows in a table box regardless of selections

Wed, 14 Sep 2016 01:29:22 GMT

I have been able to show the images in the table box by doing the following:

Select image field in the Presentation Tab...

...and click on the "Advanced" button

Then change the Representation from "Text" to "Info as Image".

Voila, we now have input fields and images in a table box.

PS: to display the images correctly, the Wrap Text - Cell Height will need to be adjusted e.g. to 8 lines as per above.

Re: Show all rows in a table box regardless of selections

ToniKautto — Wed, 14 Sep 2016 03:38:02 GMT

What is the reason you want to alter text through an input field?

The intended use case of inputfields is to alter numbers to allow "What-If" analysis. Altering text does not really add value to that, as far as I know.

Re: Show all rows in a table box regardless of selections

Wed, 14 Sep 2016 03:57:16 GMT

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...

Re: Show all rows in a table box regardless of selections

Wed, 14 Sep 2016 03:57:29 GMT

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

Re: Show all rows in a table box regardless of selections

Wed, 14 Sep 2016 07:12:04 GMT

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

Re: Show all rows in a table box regardless of selections

Jason_Michaelides — Wed, 14 Sep 2016 07:35:40 GMT

‌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.

Re: Show all rows in a table box regardless of selections

vinieme12 — Thu, 15 Sep 2016 15:34:16 GMT

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!