topic Re: Table box with editable expressions? in QlikView

Table box with editable expressions?

Tue, 08 Dec 2015 20:43:04 GMT

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.

Re: Table box with editable expressions?

Peter_Cammaert — Tue, 08 Dec 2015 21:06:43 GMT

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 ?

Re: Table box with editable expressions?

Tue, 08 Dec 2015 21:27:29 GMT

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

Re: Table box with editable expressions?

Peter_Cammaert — Tue, 08 Dec 2015 22:00:36 GMT

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

Re: Table box with editable expressions?

roger_stone — Tue, 08 Dec 2015 22:03:12 GMT

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

Re: Table box with editable expressions?

Anonymous — Wed, 09 Dec 2015 05:49:06 GMT

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.

Re: Table box with editable expressions?

prieper — Wed, 09 Dec 2015 08:22:57 GMT

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

Re: Table box with editable expressions?

Wed, 09 Dec 2015 17:16:33 GMT

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.

Re: Table box with editable expressions?

Peter_Cammaert — Thu, 10 Dec 2015 08:23:52 GMT

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

Re: Table box with editable expressions?

Thu, 10 Dec 2015 16:17:58 GMT

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.

Re: Table box with editable expressions?

Peter_Cammaert — Thu, 10 Dec 2015 16:58:27 GMT

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

Re: Table box with editable expressions?

Peter_Cammaert — Thu, 10 Dec 2015 17:06:59 GMT

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.

Re: Table box with editable expressions?

Thu, 10 Dec 2015 17:48:02 GMT

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

Re: Table box with editable expressions?

Peter_Cammaert — Thu, 10 Dec 2015 23:44:13 GMT

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

Enjoy QlikView and the Qlik Community !

Re: Table box with editable expressions?

rwunderlich — Fri, 11 Dec 2015 02:11:07 GMT

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