Solved: Table box with editable expressions? - Qlik Community

Report Inappropriate Content · ‎2015-12-08

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 · ‎2015-12-10

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

View solution in original post

Peter_Cammaert · ‎2015-12-08

Try with a straight table-simulation of a table box. See here: Is it possible to lock the table box content ? Read only table box ?

Report Inappropriate Content · ‎2015-12-08

A straight table allows me to edit expressions, but it does not show multiple counts of something like 8:00:00AM.

Peter_Cammaert · ‎2015-12-08

I do not understand why not. Maybe you should provide a screenshot or an Excel-simulation of what you are trying to accomplish. A picture is worth...

roger_stone · ‎2015-12-08

I'll guess that what you really want is a pivot table.

Anonymous · ‎2015-12-09

Hi Seong,

Can you share some picture which tells the actual problem and expected result. So that we will get an idea and could help you on this.

prieper · ‎2015-12-09

Good day,

you may add Frequency to a listbox, this will show how many occurances are behind one entry

(Properties->General->Show Frequency)

HTH Peter

Report Inappropriate Content · ‎2015-12-09

Hi, apologies but I cannot upload a picture of my data at this time, but I can try to clarify.

I have an excel sheet with multiple rows that happened at 8:00:00AM. So it'll look like

(Column A) (Column B)

8:00:00 1

8:00:00 2

8:00:00 3

If I use a table box and choose Column A and Column B, it'll display 3 rows and both columns. However, a list box, pivot table or a straight table will only show one row with time "8:00:00". I would like a way to show 3 rows AND have the ability to edit a field, for example by multiplying everything in Column B by 2. Any help is appreciated, thank you.

Peter_Cammaert · ‎2015-12-10

For a listbox to do this (it will work just fine), you need to create a unique value for every combination of values of A & B. You don't need to do this in your script, you can do it on-the-fly by creating a so called calculated dimension/field. Create a listbox and as a field name, select <Expression>. Enter something like =Column_A & ' (' & Column_B & ')'.

Now you can add whatever real expression you want (B * 2, Sum(C)/100, whatever) in the Expressions tab of the listbox. Very compact.

The same will work like a charm in a straight table, where you keep the separate (dimension) layout of Column A and Column B.

Best,

Peter

Report Inappropriate Content · ‎2015-12-10

Hey Peter,

I have tried your suggestion and I am getting some side effects. I don't see every row, possibly because Column B is sometimes empty. Also, the UI is an important part of what I'm trying to do, so I would like to avoid showing something like "8:00:00(2)", and would like for it to only have "8:00:00"

Is there any way to have a calculated field for a table box, or is there a particular reason why that's not possible? That would really be ideal for what I am trying to do, since a table box simply shows every row.