Hide the fields in Straight table in QlikSense

[#1]

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   

[paul_scotchford]

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

[reddy-s]

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.

[#4]

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 .

Regards,

sai Madhu

Reddys310‌

[#5]

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]

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.

[#7]

Hi Andy

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

Regards,

Sai Madhu

[reddy-s]

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]

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]

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)