topic Re: Hidding a Expression based on Dimensionality in QlikView

Hidding a Expression based on Dimensionality

azimabadi — Tue, 11 Jun 2013 07:31:29 GMT

Hi all,

i have a pivot with 3 dimensions.

there is a expression that i need to show only when the 3rd dimension is expanded.

in condition of expression, the return value of Dimensionality() is always 0, that means i cant use here the function.

i will appreciate any idea.

Best Regards

Peyman

Re: Hidding a Expression based on Dimensionality

RedSky001 — Tue, 11 Jun 2013 11:49:32 GMT

Have you tried, secondarydimensionality()

Taken from the help file:

returns the number of dimension pivot table rows that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates. This function is the equivalent of the dimensionality() function for horizontal pivot table dimensions.

The secondarydimensionality() function always returns 0 when used outside of pivot tables.

Re: Hidding a Expression based on Dimensionality

Gysbert_Wassenaar — Tue, 11 Jun 2013 11:58:19 GMT

See attached qvw. Is that what you're trying to do?

Re: Hidding a Expression based on Dimensionality

azimabadi — Tue, 11 Jun 2013 13:12:27 GMT

Hi Gysbert,

this is what i'm doing. but Client wants when there is no data in first column ( expression ), that means when all Regions are colapsed, i hide it ( the first expression ).

I#m not sure that it is posible.

Regards

Peyman

Re: Hidding a Expression based on Dimensionality

azimabadi — Tue, 11 Jun 2013 13:13:13 GMT

Hi Mark,

this is useful when you have horizantal dimensions in pivot.

Regards

Peyman

Re: Hidding a Expression based on Dimensionality

Gysbert_Wassenaar — Tue, 11 Jun 2013 14:04:38 GMT

No, hiding the expression column completely depending on the expanded/collapsed state of dimensions is not possible.

Re: Hidding a Expression based on Dimensionality

Mon, 24 Nov 2014 12:29:13 GMT

Hi, maybe you find a solution? that's exactly the problem i'm facing...