Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Simple question re: straight tables

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

Tags (1)
6 Replies
Highlighted
Champion
Champion

Re: Simple question re: straight tables

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

Highlighted
MVP
MVP

Re: Simple question re: straight tables

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Champion
Champion

Re: Simple question re: straight tables

Highlighted
Contributor III
Contributor III

Re: Simple question re: straight tables

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?

Highlighted
MVP
MVP

Re: Simple question re: straight tables

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

Re: Simple question re: straight tables

Hi Chris,

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

Thanks

SV