Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Hide the fields in Straight table in QlikSense

Hi All ,

How to hide the column in Straight Table in  QlikSense .what i am looking  just have a look above attachment

Regards,

Sai Madhu   

10 Replies
paul_scotchford
Valued Contributor

Re: Hide the fields in Straight table in QlikSense

Hello Sai,

Unlike QlikView, it is not possible to hide columns in a straight or pivot table.

I think what developers and users need to understand, is QlikSense lacks so many attributes that are found in

QlikView in order to keep it agile and very easy to develop visualisations with, but sometimes we need more

Paul

reddys310
Honored Contributor II

Re: Hide the fields in Straight table in QlikSense

Hi Sai Madhu,

The functionality you are looking for is not possible yet. Why do you need that column at all? What is the requirment.

Thanks,

Sangram.

Not applicable

Re: Hide the fields in Straight table in QlikSense

Hi Reddy ,

I was Created one Sample Straight table as  FieldNames are ProductName ,Month ,and Count as shown in below picture . So What's my requirement is i Don't want the Month Filed in a table i want to hide it that Field .

column hide.png

Regards,

sai Madhu

Reddys310

Not applicable

Re: Hide the fields in Straight table in QlikSense

Hello madhu,


The only solution I find is to create a variable in the script, for example

let hideVar=1

Then in your table on the Column Field where you add Month, you could write instead of Month something like

if($(hideVar)<>1,Month)

This won't make disappear the column but at least you won't see the values if the variable is activated.

PD Instead of the variable you can put the conditions required to see or not to see that field.

ogster1974
Honored Contributor II

Re: Hide the fields in Straight table in QlikSense

A possible fudge for this.

Order your month column to the right hand side of your table and reduce the space allowed for your table until the month column is auto hidden by sense.

Not applicable

Re: Hide the fields in Straight table in QlikSense

Hi Andy

This one i was tried it , is there any another way to hide the Column Fields

Regards,

Sai Madhu

reddys310
Honored Contributor II

Re: Hide the fields in Straight table in QlikSense

Hi Madhu,

The way Andy mentioned is the only way. There is no other alternative to hide a column. Check if an Aggr() function can help solve the issue with out adding the Month field as a dimension in the table.

Thanks,

Sangram.

ogster1974
Honored Contributor II

Re: Hide the fields in Straight table in QlikSense

you could create an calculated dimension of both field names in master items then have that as your column.  It at least removes and column.

shree909
Valued Contributor II

Re: Hide the fields in Straight table in QlikSense

Hi , Try this

By adding the Month name as metrics u have the option of changing the  background of the expression to  ARGB(100,255,255,255)

Community Browser