topic Re: How to disable filter in a tablebox column? in QlikView

How to disable filter in a tablebox column?

Wed, 29 Oct 2014 07:45:14 GMT

Hello Community,

i have a tablebox with five columns and a lot of rows. The user has now the possibility to filter the data by selecting one of the values in any column or row. I want, that this filterfunktion is disabled for all other columns than one. Perfect would be if the user could klick at any point in a row and only the filter of one field in this row is set.

Example : Date | Partnumber | Supplier

02.2014 0815 EXP

User can klick at the date- or Partnumber field but the filter for the supplier is set.

Thanks for your support!

Re: How to disable filter in a tablebox column?

Wed, 29 Oct 2014 07:56:05 GMT

Hi,

Create alternate state in document properties and place it in table box.

and if want to filter the table box as per the slection in supplier then same alternate state can be place in suppliers filter box.

Re: How to disable filter in a tablebox column?

jagan — Wed, 29 Oct 2014 08:04:18 GMT

Hi,

It is not possible in Table Box, instead you can try this in Straight table like below

Dimension: Date, Partnumber, Supplier

Expression: =Only({<Supplier=>} Date) - Assume Expression Name: Temp

Now go to Presentation tab and select Temp in Columns list and select Hide Column option.

Hope this helps you.

Regards,

Jagan.

Re: How to disable filter in a tablebox column?

Wed, 29 Oct 2014 08:28:58 GMT

Correct possible only in Chart type -> Straight table.

Also In Expression you can use the following:

Only (Date)

Only (Partnumber)

Only (Supplier)

Hide the dimensions: Date, Partnumber, Supplier.