Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like my expression to change if a certain dimension is present. If the dimension does not exists then I would like to use a different expression.
Is this possible in QV?
Hi Amir,
Try reading help about Dimensionality()
that only gives me the number but not the dimension name. i am looking for the dimension name to exist
Hi amirvas,
I'm also trying to do somethign similar. The idea is to make it work even if the user changes the column position in the pivot.
All we need is to be able to use the dimension name on the expression.
Hi
Did you try using
IF
(
GetCurrentField(<cyclic dimension or drill down dimension name)='<your dimension name>',then condition,else condition
)