Hide colum or other alternative?

[Anonymous]

Hi experts!

I have a table with a column   count(fieldname)

the purpose is so that the table will only show the record with count(fieldname) is 1

I want to hide this count column away, but Qlik Sense doesn't allow hide and show column yet (Qlik, you reading this?)

So is there an other alternative?

I tried to set Text Colour Expression to white to blend into the background, but the title is still there.

Thank you!

[vlad_komarov]

Jia,

There are too many UI options/features still missing in QS (comparing to QV) and this is one of them.

Do not expect it to be added soon.

But in your case, why don't you use a Set Analysis condition in your Measure (I am assuming you have at least one measure in your table) with the same purpose?

VK

[Anonymous]

Hi Vladimir,

Thks for your prompt reply.

How should I use set analysis to do this?

I have a table like this where anomalies count are  count([Anomalies]), so the records will show when anomalies field is not empty.

The black box are jus transaction numbers.

[rupamjyotidas]

top of my head, you cloud .

Expression: if(count([Anomalies])>0,' ')

Title: 'Just Give a Space'

[Anonymous]

Hi Rupam,

The expression works, but the title doesn't. When a space is used, it will show the expression instead.