Straight Table

[Jennell_Yorkman]

The straight table, included in the Visualization bundle, has all the table properties that we are used to as well as many new features. These new features make it easier for developers to create a straight table and it gives users the ability to customize straight tables in the apps they view. The straight table is ideal when you want to provide detailed data – the raw data. While you do not want to have too many columns (ten or less columns are ideal for the best performance), a straight table can have many columns (dimensions and measures).

As previously mentioned, the straight table can be added to a sheet from the Qlik Visualization bundle. This means developers will need to open the advanced options to add the straight table to their sheet(s) and make edits. Once the straight table is added to a sheet, developers can add columns – either fields and master items or custom expressions. One of the new features that developers can take advantage of to build tables quickly is the ability to add more than one dimension and/or measure at once. Simply select the dimensions and measures you would like to add to the table and then click the Add button.

Once columns are added to the table, they can be dragged as needed to the desired position/order. Developers also can add alternate columns to the straight table. These columns can be dimensions and/or measures. These alternates columns will be available to users to customize the straight table if chart exploration is enabled. This is a great new feature because the user does not need edit permissions to modify the straight table. Users can add and/or remove columns based on their analysis. Being able to add columns as needed also improves performance since the straight table does not need to display all the columns, all the time. Loading the straight table with the minimum columns needed will decrease the load time.

                  

Chart exploration allows users, who are in analysis mode, to add and remove columns from the straight table they are viewing by checking or unchecking them in the Chart exploration panel (see image below). Any users viewing the sheet can customize the straight table. Users cannot see layout changes made by other users using the app, unless they opt to share the visualization or create a public bookmark with the layout saved.

Another new feature for developers is the ability to set the column width. By default, the column width is set to Auto, but developers can set it to Fix to content, Pixels or Percentage. Pagination is another new feature that can be enabled in a Straight table. With pagination, a specified number of rows are displayed at once and the user can navigate through the pages using arrows or selecting the page.

Many of the properties for the straight table are familiar but the new ones are moving the straight table to a new level. Learn everything you need to know about the straight table in Qlik Help and add one to your next app. Also check out the SaaS in 60 video for a quick video overview:

Thanks,

Jennell

[Mark_Miron]

This is quite an improvement but it would be nice to include the ability to be able to insert Unicode characters using the Chr() function. The old straight table allows for the use of Chr(10) in the dimension expression.

[Lucke_Hallbergson]

@vincent_ardiet_ Already implemented (in engine, so everywhere)

Notice that the label set (in master dim or in drilldown/circular dimension) is used throughout in selections and global selections

//L

[vincent_ardiet_]

Thanks @Lucke_Hallbergson, the usage of the label in the selections bar is a very nice feature too, I remember having voted for this idea in the past. This doesn't seem to be already the case in the QS Enterprise on Windows, but I guess this should be the case soon, I will keep an eye on it.

[Lucke_Hallbergson]

@Mark_Miron You can

//L

[Mark_Miron]

Thanks @Lucke_Hallbergson for that clarification. I will test it out.

Still would like the option to apply these formatting options without having to create a master object every time.

[fabdulazeez]

Hi @Jennell_Yorkman 

Could you explain the purpose of the 'Adjust Column Size' option? It doesn't seem to have any effect when selected.

[Jennell_Yorkman]

Hi @fabdulazeez, this is for accessibility purposes. You can use this to adjust the column width using the arrow keys. Thank you @Patric_Nordstrom for the answer to this.

[fabdulazeez]

Thanks @Jennell_Yorkman . Thanks @Patric_Nordstrom