Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

athompsonhp
New Contributor III

Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

The Pivot Table expression conditional option does not recognize "Dimensionality()".

For example, I would like hide a column when Dimensionality() = 1.  As the user expands the pivot table to the next dimension then the calculated column will show.

Am I missing something?

1 Solution

Accepted Solutions

Re: Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

The conditional display expression can only work at the chart level, not at row level. Expanding a dimension can be done per dimension value. And it's not possible to show a column for some dimension values, but not for others that aren't expanded. A column can only be shown or hidden entirely. So it makes sense that the expression can use calculations that give a result at the chart level.


talk is cheap, supply exceeds demand
3 Replies

Re: Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

The conditional display expression can only work at the chart level, not at row level. Expanding a dimension can be done per dimension value. And it's not possible to show a column for some dimension values, but not for others that aren't expanded. A column can only be shown or hidden entirely. So it makes sense that the expression can use calculations that give a result at the chart level.


talk is cheap, supply exceeds demand
MVP
MVP

Re: Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

Here is a thought.

dimentionality.png

If you closely look at the result of the dimensionality() function, would notice that it calculates row wise. Therefore, for different rows, values could be different based on the expansion. And probably it is established that we can't hide a column on row condition. Hope this makes sense why we can't use dimensionality() function to hide a column.

athompsonhp
New Contributor III

Re: Does anyone have an idea of why Dimensionality() does not work with the Expression Conditional?

Thanks for your feedback.  I see your point.

It would seem that if values are "always available" (which they are in my case) then the dimensionality() could be used to show or hide columns.

Maybe a feature??!!

Community Browser