Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dwh1104
Creator II
Creator II

Compare Text by Row

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

Try

=above(TOTAL column(1))

View solution in original post

6 Replies
rbecher
MVP
MVP

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

Vizlib Head of R&D
dwh1104
Creator II
Creator II
Author

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
MVP
MVP

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

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

- Ralf

Vizlib Head of R&D
dwh1104
Creator II
Creator II
Author

The expression for column(1) is…

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

Thanks,

Dan

swuehl
MVP
MVP

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

Try

=above(TOTAL column(1))

View solution in original post

dwh1104
Creator II
Creator II
Author

That worked perfectly!

Thanks,

Dan