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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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

Labels (1)
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