Compare Text by Row

[dwh1104]

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.

[rbecher]

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

[dwh1104]

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

[rbecher]

But what is the expression of "column(1)" ?

You'll need an aggregation function, else Only() will be used.

- Ralf

[dwh1104]

The expression for column(1) is…

=only({1<[Email Dashboard]={1}>}[Network User Name])

Thanks,

Dan

[swuehl · Accepted solution]

If you are using more than 1 dimension, you'll need to take care of the column segments.

Try

=above(TOTAL column(1))

[dwh1104]

That worked perfectly!

Thanks,

Dan

[sagarpawar]

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