topic To hide column from a table box in QlikView

To hide column from a table box

Tue, 11 Mar 2014 08:54:39 GMT

Hi,

I have a table box with almost 20 columns. I do not want to display all the columns, I would need to display only few columns, but when i send to excel, i need all the 20 columns in excel.

So my view, if i can hide the columns on a table box, my display would be limited at the same time on send to excel i get all the columns.

Any help around this ?

Thanks !!

Re: To hide column from a table box

sujeetsingh — Tue, 11 Mar 2014 08:57:30 GMT

USE STRAIGHT TABLE

Re: To hide column from a table box

Tue, 11 Mar 2014 09:04:44 GMT

Using straight table will solve half of the issue. I have hide columns, but when i send to excel...only displayed columns will be exported but not hidden columns

Thanks !!

Re: Re: To hide column from a table box

sudeepkm — Tue, 11 Mar 2014 09:21:05 GMT

May be you can have two straight tables.

First one with Layout as Top and with few columns hidden and hide the caption

Second one with Layout as bottom with all columns visible and Show caption in such a way that the two tables look like single table. The export to excel will export data from second table which has all the columns visible.

Please take a look at the QVW attached.

Re: Re: To hide column from a table box

Tue, 11 Mar 2014 09:21:14 GMT

Hi Sunil

Send to excel will do just that - send exactly what you have on the screen to excel. The alternative is to create a copy of the table, but with all the columns showing, for export.

To automate the export (and have it still work in AJAX, assuming that is what you are using) would be to either:

1) Use a button - add the external action "export" and in the setup specify the columns you need and CSV (although not strictly an excel document), if this is possible

2) Shrink the table and overlap some items on it so only the excel button shows - eg

then instruct your users to use this button!

Erica

Re: To hide column from a table box

MK_QSL — Tue, 11 Mar 2014 09:21:46 GMT

May be someone can suggest you a Macro which can solve your problem.

Re: Re: To hide column from a table box

Tue, 11 Mar 2014 09:22:50 GMT

Another alternative would be a button, that when you press it does these actions:

1) sets the variables controlling whether the columns are visible, so that they are visible

2) exports to csv

3) returns the columns back to normal again

Erica

Re: Re: To hide column from a table box

Tue, 11 Mar 2014 09:23:48 GMT

Sunil are you using AJAX?

Re: To hide column from a table box

Tue, 11 Mar 2014 09:27:29 GMT

Hi Erica,

Nope. I`m not using AJAX. The other alternative solution from Sudeep & your suggestion on using a button to make column visible / hide should work.

Any particular reason about asking if I`m using AJAX?

Thanks !!

Re: To hide column from a table box

Tue, 11 Mar 2014 09:56:15 GMT

Thanks all !!

Re: To hide column from a table box

Tue, 11 Mar 2014 10:06:33 GMT

Because macro's don't always work on the web when you are using AJAX. But if you are not using it, then no need to worry

Re: To hide column from a table box

manojkulkarni — Tue, 11 Mar 2014 10:11:19 GMT

which one is the correct answer ? pls put the solution here,so others can get benefited.