topic Re: Table Boxes - hide certain values? in QlikView

Table Boxes - hide certain values?

Wed, 15 Oct 2014 20:43:00 GMT

Hi all -

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

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
Rocks	UNKNOWN	Dirt	Cement	John	1000	ADK	Accounting
Stick	11223	Dirt	Sand	Dave	1245	ADK	Expenses
Sticks	UNKNOWN	Water	Sand	Randy	882	KFL	Expenses
Soil	12522	Dirt	Cement	Sue	9912	PLK	Accounting
Masonry	18297	Water	Gravel	Larry	9901	KPA	Management
Masonry	UNKNOWN	Water	Gravel	Larry	9901	KPA	Management

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!

Re: Table Boxes - hide certain values?

its_anandrjs — Wed, 15 Oct 2014 20:45:37 GMT

Try with expression

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

Re: Table Boxes - hide certain values?

Wed, 15 Oct 2014 20:48:42 GMT

As the calculation condition?

Re: Table Boxes - hide certain values?

maxgro — Wed, 15 Oct 2014 20:49:15 GMT

is it an option to add a listbox?

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

Re: Table Boxes - hide certain values?

Wed, 15 Oct 2014 20:51:25 GMT

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

Re: Table Boxes - hide certain values?

Anonymous — Wed, 15 Oct 2014 21:03:32 GMT

You can create a calculated dimension

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

Re: Table Boxes - hide certain values?

Wed, 15 Oct 2014 21:10:32 GMT

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

Re: Table Boxes - hide certain values?

Anonymous — Wed, 15 Oct 2014 23:22:30 GMT

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

Re: Table Boxes - hide certain values?

Mon, 16 May 2016 15:28:21 GMT

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.