topic Re: Table box hide column and show selected value in QlikView

Table box hide column and show selected value

Sat, 07 May 2016 15:08:27 GMT

I have a tablebox with two columns "ShipCity","ShipCountry" (as per attached scree shot)

I want the data should be displayed based on filter for eg ShipCountry="France" and also the want to hide "ShipCountry" column.

Re: Table box hide column and show selected value

swuehl — Sat, 07 May 2016 21:48:08 GMT

Use a straight table chart instead of a table box.

Use two dimensions, ShipCity and ShipCountry

Use one expression

=sum({<ShipCountry = {'France'}>} 1)

On presentation tab of chart properties, check that 'suppress zero values' option is enabled and hide columns for dimension ShipCountry and the single expression.

Re: Table box hide column and show selected value

MarcoWedel — Sun, 08 May 2016 00:51:48 GMT

You could create a drill down dimension group consisting of your fields "ShipCity" and "ShipCountry" and use this in a ListBox.

regards

Marco

Re: Table box hide column and show selected value

MarcoWedel — Sun, 08 May 2016 01:20:09 GMT

maybe like this:

regards

Marco