Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How count disable dimensions

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

3 Replies
chiru_thota
Specialist
Specialist

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) 

maxgro
MVP
MVP

=GetSelectedCount(dimension)

or GetPossibleCount

Not applicable
Author

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