Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.

jagan
Luminary Alumni
Luminary Alumni

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
Author

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.