topic hide a table column in QlikView

hide a table column

Fri, 05 Jun 2009 02:10:45 GMT

I did search the forum before opening this, but didn't find an answer.

Requirement is to hide a straight & pivot table for all users except some AD IDs. Also in some tables, need to hide a particular column if not in the allowed AD ID list. How to achieve both? Thanks

hide a table column

Oleg_Troyansky — Fri, 05 Jun 2009 02:19:17 GMT

Currently, there is not way to conditionally hide a column ( I think there is an enhancement in v9.0, but I'm not totally sure).

You'd need to manage duplicate copies of your charts - one with all columns and another one without some columns. Use "Show Condition" to determine what object to show to the current user. You can link it to your Section Access definitions (see chapter "Security" in the Reference Guide).

good luck!

Oleg

hide a table column

Fri, 05 Jun 2009 02:54:58 GMT

Thank you.

hide a table column

Anonymous — Fri, 05 Jun 2009 03:48:20 GMT

Technically, it is possible by using a macro that changes columnwidth to 0.

hide a table column

Wed, 28 Apr 2010 12:01:04 GMT

I noticed that with QlikView 9.0, the object "linear table" (I hope Italian->English translation of the object is correct) allows you to hide columns conditionally.
I created a "support" table with only one column (named Security) and with values 1,2,3.

If I want to hide conditionally a column in a linear Table, I simply add the following script:
= If (minstring (SECURITY) = 1, true (), false ())

Then, when I select Security = 1, the column is hidden

I think this system can be used for your purpose too

hide a table column

johnw — Wed, 28 Apr 2010 21:43:47 GMT

It's a "straight table" in the English version of QlikView. The most common definition of "straight" is a synonym for "linear", so "linear table" is a very good translation, and does make sense. In the Webster's English Dictionary, that would be definition 1a. However, I think of a "straight table" as being more like definition 3c, "free from extraneous matter". It is a simple table, with just the data, "free from extraneous matter" like bars and lines and pivoting and so on. Of course, I have no idea if that's why QlikTech named it a straight table in the English version, and of course we CAN add bars and lines and so on to straight tables these days. So I don't know if I'm thinking of it the way QlikTech is thinking of it - maybe they're thinking of it as a linear table, which it also is.

http://www.merriam-webster.com/dictionary/straight

Heh, sorry. I find language fascinating, even if I'm embarrassingly monolingual.

hide a table column

Tue, 25 May 2010 08:09:12 GMT

Hi,i have an issue where I have to make a column appear only at drill down level. I am using V8.5 QV. Any suggestion how to do this.

I thought that i could simply insert a condition in the expression itself but i dont know the syntax for setting the column to appear or to disappear .

hide a table column

Wed, 09 Jun 2010 09:35:31 GMT

There is a way to hide columns in "straight table" but what about "pivot table"??

hide a table column

johnw — Wed, 09 Jun 2010 20:06:25 GMT

Depends on what you mean by hiding a column. Let's say you have a table of products across the top, dates down the side, and sum(Sales) as your expression. It will show all products for all dates (at least where there are sales). If you want to hide a product, you could do sum({<Product-={'Bad Product'}>} Sales), for instance. That Product would then disappear. Another way would be to use a calculated dimension of if(Product<>'Bad Product',Product). Either way would cause column 'Bad Product' to disappear.

Not sure how to cause a pivot table expression to completely disappear based on a condition, though, other than the "old school" approach of making two different charts, one with and one without the column, and conditionally displaying the charts. Well, or macro logic to add and remove the column, or other such ugliness.

hide a table column

Thu, 10 Jun 2010 05:35:32 GMT

I understand what you mean, but this would address only field values and would still display the columns with empty cells. In the meantime i have resorted to using the columns i dont want to appear as dimensions of the table, so that you will have the "Expand" or "collapse" sign next to it. Appreciate the information you given me, it might come in handy.

hide a table column

Fri, 18 Jun 2010 08:08:52 GMT

My aim to hide the coloumns is;

Do the basic calculation at one column and then use this result at the other columns repeatedly.

So removing, adding columns is not a solution for me, because I need to use the columns while they are hidden.

I give a sensible name to my calculated column and show to user. So there is no need to hide it any more, my problem is considered to be solved for now.

hide a table column

Anonymous — Fri, 18 Jun 2010 14:36:54 GMT

Here is a macro I'm using somitimes to hide column in pivot:


sub Squeeze
 call HideColumn("CH01", 2)
end sub
'
private sub HideColumn(ch, n)
 set ch = ActiveDocument.GetSheetObject(ch)
 ch.SetPixWidth (n-1), 0
end sub

hide a table column

Fri, 18 Jun 2010 16:21:52 GMT

Thank you Michael, your code is helpfull !