topic Compare Text by Row in QlikView

Compare Text by Row

dwh1104 — Mon, 12 Aug 2013 20:56:07 GMT

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.

Re: Compare Text by Row

rbecher — Mon, 12 Aug 2013 21:01:56 GMT

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

Re: Compare Text by Row

dwh1104 — Mon, 12 Aug 2013 21:25:24 GMT

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

Re: Compare Text by Row

rbecher — Mon, 12 Aug 2013 21:33:28 GMT

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

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

- Ralf

Re: Compare Text by Row

dwh1104 — Tue, 13 Aug 2013 12:21:19 GMT

The expression for column(1) is…

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

Thanks,

Dan

Re: Compare Text by Row

swuehl — Tue, 13 Aug 2013 12:25:23 GMT

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

Try

=above(TOTAL column(1))

Re: Compare Text by Row

dwh1104 — Tue, 13 Aug 2013 12:29:27 GMT

That worked perfectly!

Thanks,

Dan

Re: Compare Text by Row

sagarpawar — Mon, 06 Dec 2021 04:01:14 GMT

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