topic Re: Collapse Expression Columns in QlikView

Collapse Expression Columns

Mon, 07 May 2012 14:48:04 GMT

I am trying to have a Pivot Table where some of the Expression Columns are hidden when the dimension is collapsed. I want one table to show summary level information and then show detail level data when the dimension columns are expanded. Is there a way to do this?

Example:

Branch Name Sales Person Buyer Name Buyer Address Order# Units Sold Amt

Using the above headers, I want Branch Name and Sales Person to be collapsable (my dimensions). When those are collapsed, the only expressions that I want shown are the totals for Units Sold and Amt (my expressions). When the user expands the Sales Person column, the Buyer Name, Buyer Address, and Order# are shown as details. It is easy to get one column to be hidden by making it a dimension, so if I make Buyer Name a dimension, it will be hidden until Sales Person is expanded. However, the Buyer Address is still visible at all times. If I make Buyer Address a dimension, then Buyer Name becomes expandable and collapsable which I do not want.

Collapse Expression Columns

Mon, 07 May 2012 15:01:02 GMT

Use Dimensionality.

Create a new expression: Dimensionality()

This will diplay numbers. Collapse the dimensions to the levels that you do not wish to see any data in some of the expressions. Take note of the numbers displayed in the new expression.

In the expressions that you wish to hide use a formula if(Dimensionality<> Number, Expression)

Re: Collapse Expression Columns

Mon, 07 May 2012 17:47:30 GMT

Thanks marcsliving, this helps, but it only hides the values, not the actual column. When everything is collapsed the only visible expression columns should be Units Sold and Amt.

I've also tried using the Dimensionality() function in the Conditional with no success.

Re: Collapse Expression Columns

Wed, 09 May 2012 18:19:25 GMT

NOTE: This is not resolved. Does anyone else have any suggestions?

Collapse Expression Columns

Thu, 31 May 2012 14:00:47 GMT

I played with it a little more and still haven't found a way to do this. Any help on this?

Re: Collapse Expression Columns

Thu, 21 Jun 2012 13:20:46 GMT

Bumping this back to the top of the list since it is still unresolved.

Re: Collapse Expression Columns

Anonymous — Fri, 08 Nov 2013 15:18:49 GMT

Hello everybody,

I have the same problem and I can't find any solution in the Community. This is why I want to reopen this post and bump it back to the pop.

Please help if there is any solution the show/hide expression by using the conditional function for every expression.

Dimensionality() does not work in this field.

Thanks in Advance

Re: Collapse Expression Columns

raajaswin — Thu, 23 Aug 2018 15:39:49 GMT

Even I have the same problem.. Any solution to hide Expression column based on dimensionality

Re: Collapse Expression Columns

LynLuyt — Sat, 09 Feb 2019 10:51:03 GMT

I have the same problem. It's really frustrating.