Table box with editable expressions?

[#1]

Hi, is it possible to have a table box with expressions that I can edit? I can use a list box to have editable expressions, but only a table box shows all of my data, even with duplicate entries.

For example, I have data that occurred at 8:00:00AM, but I have multiple data points at that time. A table box shows each event that occurred, but a list box will not. If there is some other sheet object that can show data with the same timestamp and have the ability to show editable expressions, that would work, too.

[Peter_Cammaert · Accepted solution]

You should try a straight table then.

Table Boxes don't allow expressions. A Table Box is like a parallel set of listboxes showing all unique combinations of values from the different fields, but only once. IMHO a table box is highly useful for debugging purposes, but I don't use it for anything else (because of its limitations)

A table box will not show every row in your internal table. It will show every unique combination of field values, including NULL values. That's what it is meant to do and nothing else.

I don't know why it isn't possible to do what you want. I didn't design QV (or these days it would look completely different anyway ) And I don't think it's a handicap because there are alternatives.

If the alternate solutions don't fit your bill, you can always try designing your own object object type. Search for "QlikView Extensions" for more inifo.

Best,

Peter

[Peter_Cammaert]

This are two table box simulations in a straight table. I did use your data example from up above. On the left just A and B, on the right A + B and an expression of B * 2. All selectable like table box entries.

[#4]

Your comment actually made me realize I set up my data in a way that caused my problem, thanks!

[Peter_Cammaert]

My pleasure, and glad to be able to provide insights.

Enjoy QlikView and the Qlik Community !

[rwunderlich]

Note that in a Straight Table, you can simply add "Column B" as a Dimension and then select "Hide" for the column on Presentation pane. You will not see ColumnB, in the table, but you will get three rows for 08:00.

-Rob