topic Hiding a column in a List box in QlikView

Hiding a column in a List box

Wed, 26 Mar 2014 11:18:08 GMT

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

Re: Hiding a column in a List box

PrashantSangle — Wed, 26 Mar 2014 11:21:08 GMT

Hi,

Can you post Example,

Regards

Re: Hiding a column in a List box

its_anandrjs — Wed, 26 Mar 2014 11:21:37 GMT

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

Re: Hiding a column in a List box

Wed, 26 Mar 2014 11:23:08 GMT

Hi Hamster70

please attach the snap of your problem

Re: Hiding a column in a List box

DavidFoster1 — Wed, 26 Mar 2014 11:24:07 GMT

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?

Re: Hiding a column in a List box

Wed, 26 Mar 2014 11:26:29 GMT

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

Re: Hiding a column in a List box

tresB — Wed, 26 Mar 2014 11:27:24 GMT

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.

Re: Hiding a column in a List box

fernando_tonial — Wed, 26 Mar 2014 11:38:59 GMT

Hi Graham,

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

Best Regards.

Re: Hiding a column in a List box

Wed, 26 Mar 2014 12:04:06 GMT

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

Re: Hiding a column in a List box

tresB — Wed, 26 Mar 2014 12:07:30 GMT

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.

Re: Hiding a column in a List box

sudeepkm — Wed, 26 Mar 2014 12:09:10 GMT

I think you want to hide the Field in the List box and keeping the expression only visible.

That you can do it by selecting the divider line (invisible by default) between the Field and the Expression of the List box and then drag to the left like below.

Re: Hiding a column in a List box

sudeepkm — Wed, 26 Mar 2014 12:13:27 GMT

Just wanted to check what exactly you will get if you do so. Hiding the Dimension field may not make sense as the end user will never be able to understand the number without any references.

Also just to show the number it is better to use as suggested by tresesco instead of dragging the divider line.

Re: Hiding a column in a List box

DavidFoster1 — Wed, 26 Mar 2014 12:16:23 GMT

Alternatively look at the DUAL function as an option for a text value with a numeric equivalent value.

Re: Hiding a column in a List box

fernando_tonial — Wed, 26 Mar 2014 12:22:12 GMT

Use the function Macth()

Match(Departments,'Sales','Payments','Departments1',.....)

Re: Hiding a column in a List box

Wed, 26 Mar 2014 12:29:14 GMT

Hi Tresesco,

This gives me the order 1 - 6, but I also need the name of the department next to the correct number. (i.e. 1 = Sales, 2 = Payments etc...)

Re: Hiding a column in a List box

tresB — Wed, 26 Mar 2014 13:04:08 GMT

Second expression, simply: =Departments ?

Re: Hiding a column in a List box

Thu, 27 Mar 2014 10:25:05 GMT

Hi Sudeep,

How do you unhide the divider line?

Cheers

Graham

Re: Hiding a column in a List box

sudeepkm — Thu, 27 Mar 2014 10:38:30 GMT

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.

Re: Re: Hiding a column in a List box

jagan — Thu, 27 Mar 2014 10:53:13 GMT

Hi,

Please find attached file.

Regards,

Jagan.