topic How To Hide Column in Qlik Sense Straight Table in App Development

How To Hide Column in Qlik Sense Straight Table

akshay_chavan — Thu, 31 Mar 2022 15:21:06 GMT

Hi All,

Hope you all are doing good!!

I need a help of you on a following point.

I am having following straight table in Qlik sense,

Dim	Dim	Measure
A	B	C
2021	abc	1
2020	xyz	1
2022	mno	0

I want to hide the A and C column and only wanted to show the B column which having the '1' value in column C.

but when I hide column C it shows the all the rows of column B which having '0' also.

Column C is calculated measure on front end and also column B is calculated dim on front end.

How I can achieve this scenario in Qlik sense.

Kindly please provide the solution on it else if you have any alternative to do this, please share it here.

Thanks and Regards,

Akshay Chavan

Re: How To Hide Column in Qlik Sense Straight Table

AJ_Ruggiero — Thu, 31 Mar 2022 18:36:56 GMT

Hi @akshay_chavan ,

Unfortunately, Qlik Sense does not have the "hide column" functionality. However, there are some extensions that allow you to hide columns, but only on regular tables.

For example, VizLib has one:

https://community.vizlib.com/support/solutions/articles/35000107234-vizlib-table-properties-data-and-data-handling

Re: How To Hide Column in Qlik Sense Straight Table

McDonald-1022 — Thu, 24 Aug 2023 15:10:41 GMT

Yes it is possible. Click on the field, go to Presentation, go to Show Column If, then in the expression, find a field that exists and set to a result that will never show. For Example [Flag]='Show'

Re: How To Hide Column in Qlik Sense Straight Table

Tool_Tip — Sun, 01 Sep 2024 06:50:31 GMT

When you apply [Flag]='Show' condition it will surely hide the column as this condition does not exist in the model.

But, if you have any add on condition already apply to this column for example you are not showing null from this column (you have unchecked the show null ) and on top of it if you apply [Flag]='Show' condition then null condition will not be considered in the table records...