topic How count disable dimensions in QlikView

How count disable dimensions

Mon, 03 Nov 2014 19:42:26 GMT

Hi everybody,

I have a pivot table with 10 dimensions, some of them disabled. The user select in a Inline Field what fields he wants to see, but it will never be all selected together

I need obtain always the total number of dimensions, 10 in this case.

I'm thinking in something like this:

GetObjectField(Dimensionality())

but Dimensionality only counts enabled dimensions.

Some Ideas?

Thank's.

Pol

Re: How count disable dimensions

chiru_thota — Mon, 03 Nov 2014 20:03:07 GMT

Hi Pol,

why can't you use your Inline field ( Dimension) and take count of the values in it.

So that you always you will get total no of dimensions irrespective of your selected/enabled dimensions.

thanks,

Chiru

Ex : Count({1}%PivotDimensions)

Re: How count disable dimensions

maxgro — Mon, 03 Nov 2014 20:08:11 GMT

=GetSelectedCount(dimension)

or GetPossibleCount

Re: How count disable dimensions

Mon, 03 Nov 2014 20:45:37 GMT

Thanks Chiranjeevi, but the Inline Filed contains only 3 values and every wich of them enable differents dimensions groups in the chart. (for example, 1 value in Inline Field, 3 dimensions on chart)

And perhaps in the future these groups change, so I need to do variable.

Regards,

Pol

PD: Sorry for my english