Solved: Re: Hiding a column in a List box - Qlik Community

Report Inappropriate Content · ‎2014-03-26

Hi,

Can you hide a column in a list box. I've got two columns the second is an expression, I would like to hide the first one.

Rgds

Graham

sudeepkm · ‎2014-03-27

I do not think in a List Box that (A Straight Table or Table box cell look alike) is possible.

In List box we can only enable horizontal Cell border.

View solution in original post

PrashantSangle · ‎2014-03-26

Hi,

Can you post Example,

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

its_anandrjs · ‎2014-03-26

Hi,

I dont understand a requirement but can you ask for hiding any list box then go to layout properties and load condinally

can you explain more.

Hope this helps

Thanks & Regards

Report Inappropriate Content · ‎2014-03-26

Hi Hamster70

please attach the snap of your problem

DavidFoster1 · ‎2014-03-26

I think the answer is 'No'. BUT did you know that if you scroll to the bottom of the field list in the the List Box properties then you can select <expression> and input an expression directly?

Report Inappropriate Content · ‎2014-03-26

I saw that, the problem is my expression is based on the first columns information.

tresesco · ‎2014-03-26

May be you are trying to show something like Sum(Amt) against a dimension. And you don't want the dimension values to be visible. If so, you might not need a dimension/field. You can write your expression, something like:

=Aggr(Sum(Amt), Yourdimension)

Hope this helps.

fernando_tonial · ‎2014-03-26

Hi Graham,

This isn't possible. Maybe you try with a Straight Table. See my example.

Best Regards.

Don't Worry, be Qlik.

Report Inappropriate Content · ‎2014-03-26

Hi Fernando,

I've got a field (Departments) I'm trying to show but it has to be sorted in a particluar order. I'm using the RowNo() expression but this only works if the Departments field is already there.

Any ideas?

Rgds

Graham

tresesco · ‎2014-03-26

Have you tried expression like:

=Aggr(RowNo(), Departments)

?

Add: This would not require Departments to be there. You can use this expression directly as expression instead of a field.