Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to compare text from a column in one row to the text of a column in a previous row? It appears that the Above() function onlt works with values, rather than text.
If you are using more than 1 dimension, you'll need to take care of the column segments.
Try
=above(TOTAL column(1))
Hi Dan,
Above() works with expressions. So, what is your text expression in your chart?
Or, do you mean during LOAD time (QV Script)?
- Ralf
I am trying to get this to work in an expression.
It is somewhat working, but I am coming up with NULL values.
For the "NPrint Recip Name_num" expression, I have
=above(column(1))
cid:image001.png@01CE9778.83FC1AD0
Thanks,
Dan
But what is the expression of "column(1)" ?
You'll need an aggregation function, else Only() will be used.
- Ralf
The expression for column(1) is…
=only({1<[Email Dashboard]={1}>}[Network User Name])
Thanks,
Dan
If you are using more than 1 dimension, you'll need to take care of the column segments.
Try
=above(TOTAL column(1))
That worked perfectly!
Thanks,
Dan
Hi Swuehl,
Can you please help me with below scenario.
I have 2 different Geo (Geo , Geo2)tables with different column name for Country, Region and MCO.
If user select Country(=France) from Geo table country filter then same Country (=France) should select from Geo 2 table column Country.
Same for Region and MCO.
Thanks & Regrads,
Sagar