Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to disable filter in a tablebox column?

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!

3 Replies
Not applicable

Re: How to disable filter in a tablebox column?

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.

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to disable filter in a tablebox column?

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.

Not applicable

Re: How to disable filter in a tablebox column?

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, PRowLevelFilter.PNG.pngartnumber, Supplier.