Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Boxes - hide certain values?

Hi all -

Suppose I have a table box displaying a number of values across a number of fields.

Column 1 Column 2Column 3Column 4Column 5Column 6Column 7Column 8

Rocks

UNKNOWNDirtCementJohn1000ADKAccounting
Stick11223DirtSandDave1245ADKExpenses
SticksUNKNOWNWaterSandRandy882KFLExpenses
Soil12522DirtCementSue9912PLKAccounting
Masonry18297WaterGravelLarry9901KPAManagement
MasonryUNKNOWNWaterGravelLarry9901KPAManagement

If I just put in the fields (Column 1-8), the table would display exactly as above.  What if, however, I want to display the same fields but hide all lines where the value is UNKNOWN for Column 2?  Thanks!

8 Replies
its_anandrjs

Try with expression

If( [Column 2] = 'UNKNOWN' , ' ', [Column 2] )

Not applicable
Author

As the calculation condition?

maxgro
MVP
MVP

is it an option to add a listbox?

=if([Column 2]='UNKNOWN', 'UNKNOWN', 'OTHER')

Not applicable
Author

No - the object must display as a table so that it can be exported as such to Excel.

Anonymous
Not applicable
Author

Hi

You  can create a  calculated dimension

if( [Column 2] <> 'UNKNOWN' ,[Column 2] )

Not applicable
Author

Would this be done in the Load Script, or elsewhere?  There's no option for a calculated dimension in a Table Box.

Anonymous
Not applicable
Author

right clik on your table properties in the dimensions tab , there is a button called add dimension calculated

Not applicable
Author

No, there's no Dimension selection in a table box. Build a new Chart Box with Dimensions selected as the same columns in your table and add a single expression to count the lines (you can hide the expression). Now you can add a new calculated Dimension as above.