Reference value of a dimension in the previous row that is visible of a straight table

[SBN]

Hi there fellow QlikSensians,

I'm trying to reference the value of a dimension in the previous row of a straight table in Qlik Sense.
This is what I'd like to accomplish.

Order	Customer	Date	Sales person	Previous Sales person
1	Customer1	1-5-2023	Sales person 1	-
2	Customer2	1-5-2023	Sales person 2	Sales person 1
3	Customer1	2-5-2023	Sales person 1	Sales person 2
4	Customer2	2-5-2023	Sales person 2	Sales person 1
5	Customer1	3-5-2023	Sales person 1	Sales person 2
6	Customer2	4-5-2023	Sales person 2	Sales person 1
7	Customer2	2-5-2023	Sales person 3	Sales person 2
8	Customer1	4-5-2023	Sales person 3	Sales person 3

This is what I've come up with so far in my app...😁

As you can see some of the rows are showing data, but other aren't.

The previous row value should be shown based on the rows shown in the table. So also if there are selections made, the previous value should be that of the visible previous row.

The attached QVF is just a simplified example to try to accomplish this.

Thanks in advance,

SBN

[Sabrina_V · Accepted solution]

Hello,

I'm succeed with this formula : =Aggr(above([Sales person]),Order)

[SBN]

Hi @Sabrina_V,

Thank you very much for your time and effort!
This works perfectly in my simplified example as you've shown in your screenshot.
I'm going to translate this into the more complicated requirements in the customer app...😉

Kind regards,

SBN

[SBN]

Hi @Sabrina_V,

I've tried this again, but this doesn't work quite as wel as I thought in the beginning...😉
When I sort the several columns the "previous" row doesn't change with it.
Also when I make a selection this column doesn't change with it.

Thanks again for your efforts, I really appreciate it.
Do you have any other suggestions that will help me solve this?

Kind regards,

SBN