Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The Qlik Sense chart function GetObjectDimension(n) returns the nth dimension in a pivot table, where n=0 is the first row-dimension. But what about getting the first column dimension?
Let's say I have three row dimensions and three column dimensions in a pivot table. The row dimensions can be retrieved with GetObjectDimension(0..2) and I can get the column dimensions with GetObjectDimension(3..5).
But I can't be sure that there is always a fixed number of row dimensions, and therefore I can't actually get the first column dimension since I don't know what index number it may have!
Is there a solution to this, or is it not possible?
It seems this is not possible, but I'll comment my own old post now to bump it and maybe someone will have something clever to say...