Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nboccassini
Contributor

Expanded dimension

Hi,

is there a way to know if a dimension is expanded or not in a pivot table with 2 or more dimensions (indent style)?

5 Replies

Re: Expanded dimension

Gabriele

Personally I find the + & - signs, top right of the dimension value, more than sufficient.

Best Regards,     Bill Markham

nboccassini
Contributor

Re: Expanded dimension

I mean as a condition in an expression

jerem1234
Valued Contributor II

Re: Expanded dimension

The dimensionality() function should be what you're looking for. For the first dimension, it should return 1, when its expanded to the second dimension, the value will turn to 2, and so on.

Hope this helps!

Not applicable

Re: Expanded dimension

Hi,

You can use Dimensionality function in an expression

nboccassini
Contributor

Re: Expanded dimension

In point of fact I want to resolve this problem Hide row in pivot table, so I'm trying different ways.

Community Browser