Discussion Board for collaboration related to QlikView App Development.
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
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)
=GetSelectedCount(dimension)
or GetPossibleCount
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