Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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.
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.
Hi Andy
This one i was tried it , is there any another way to hide the Column Fields
Regards,
Sai Madhu
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.
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.
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)