topic Re: Hide column in pivot table in QlikView

Hide column in pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a pivot chart. The RowID column is there for a technical reason and not a functional need.

I have looked the Presentation tab and don't see anything which I might be able to use. How can

I hide this column?

Thanks!!

Re: Hide column in pivot table

Anonymous — Tue, 11 Oct 2016 15:27:34 GMT

Correction: It's a table box not pivot chart.

Re: Hide column in pivot table

beck_bakytbek — Tue, 11 Oct 2016 15:32:15 GMT

Hi Sydney,

i had such issue in the case with Pivot,

take a look: expand pivot via macro

i hope that resolves your issue

beck

Re: Hide column in pivot table

sunny_talwar — Tue, 11 Oct 2016 15:32:38 GMT

There is no way to hide a column in table box. You can only do this in straight table

Re: Hide column in pivot table

vinieme12 — Tue, 11 Oct 2016 15:37:52 GMT

Use a straight table as sunny has suggested, just uncheck the below on the presentation tab

suppress null

suppress missing

Re: Hide column in pivot table

Anonymous — Tue, 11 Oct 2016 15:38:13 GMT

The reason I need the RowID is because the table box doesn't function properly without it. Here's the question I posted: Table box count not matching with database

Now that I got the table box counting correctly but they don't let you hide it.

This means my users have to see it.

Re: Hide column in pivot table

Anonymous — Tue, 11 Oct 2016 15:40:20 GMT

OK, let me play around with the straight table. I don't have anything to calculate though. I simply want to show the data

as they appear in MSSQL to the users.

Re: Hide column in pivot table

Anil_Babu_Samineni — Tue, 11 Oct 2016 15:48:11 GMT

If it's table box. Then remove that field from table box. What is the problem to remove the field

Re: Hide column in pivot table

Anonymous — Tue, 11 Oct 2016 15:56:26 GMT

If I remove it, I am LOSING lots of records when I export it to Excel.

Please read this post:

Table box count not matching with database

Re: Hide column in pivot table

Peter_Cammaert — Tue, 11 Oct 2016 15:59:41 GMT

A table box is a combination of list boxes. It is not a table, and it surely doesn't show the contents of a database table.

Re: Hide column in pivot table

Peter_Cammaert — Tue, 11 Oct 2016 16:01:01 GMT

Use a straight table, and use some dummy expression (and RowNo) to simulate an Excel worksheet.

Re: Hide column in pivot table

Anonymous — Tue, 11 Oct 2016 19:03:19 GMT

Just wanted to say thank you. You're guys are great! I managed to convert my table box to a straight table now and with the RowID hidden. Every day is a learning day.