topic Re: Simple question re: straight tables in QlikView

Simple question re: straight tables

cfountain72 — Sun, 29 Nov 2015 19:15:57 GMT

Can someone tell me if, when using Straight Tables, you can keep the full or Top X list of values, instead of only showing the selected one(s)? In other words, use the behavior found in the List Box, but I need to show multiple columns.

Thanks in advance,

Chris

Re: Simple question re: straight tables

Anonymous — Mon, 30 Nov 2015 08:17:49 GMT

Are you talking about Top/Bottom analysis in Straight Table?

Re: Simple question re: straight tables

jonathandienst — Mon, 30 Nov 2015 08:19:07 GMT

If you have a column that is independent of the selections, either by using a set expression override of the selections, or a constant value, then the rows will always display. In a straight table you can hide this column in the presentation tab.

Re: Simple question re: straight tables

Anonymous — Mon, 30 Nov 2015 08:19:50 GMT

is this you are looking for??

How to display Top 5 records in straight table

Pivot Table top 10

Top 10 rows and total of top 10

Re: Simple question re: straight tables

cfountain72 — Mon, 30 Nov 2015 12:24:13 GMT

Thanks Jonathan,

Haven't moved into Set Expressions yet. I did create a simple Constant (1) value to add as a Dimension to the straight table. But, when I click on a row, all of the other rows still disappear. Do you have an example of what you have described?

Re: Simple question re: straight tables

jonathandienst — Tue, 01 Dec 2015 05:57:45 GMT

Add the constant as an expression, not a dimension.

To ignore selections in a field, use a set expression like the examples below:

Avg({1} Amount) -- ignore all selections

Count({<Group=>} ID) -- to ignore selections in Group

Sum({<Region, Month>} Amount) -- to ignore Region and Month selections (the = is optional)

Re: Simple question re: straight tables

Tue, 01 Dec 2015 06:19:36 GMT

Hi Chris,

You may try Dimension Limits Tab to look for top n values.

Thanks