Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a huge Pivot table with a lot of dimensions
Is there a way to limit (showing X first values of at least 2 different dimension ?)
Thanks
In fact I'm more or less looking for an equivalent of this QlikView parameter:
Dimensionality:
If(Rowno()=1 and Dimensionality()=4 ,sum(Sales) <Your Exp>)
Dimensionality will be count of dimensions you have.
Using Rank:
If(Rank(sum(Amount))<=2,sum(Amount))
Thanks, that's a good start. Please note I'm trying to display the N available values for a Dimension and NOT the Top N values of a measure
You can use rank and acheive it. still if any, pl drop some sample data and desired output.
I suggest to re-think the task. Of course it's possible to count the number of available dimension-values for single fields as well as in their combination and/or to rank the expression-results even in regard to their position - dimensionality() and/or rowno() / columnno() - to restrict the view. But the efforts for it could become quite exhausting and also causing some performance decrease by larger datasets.
Therefore I could imagine that dividing the view into n appropriate designed charts - maybe secured with a condition on the object-visibility like: count(distinct Dim1&Dim2&Dim3&Dim4) < 1000 may be more expedient.