Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
SBN
Contributor III
Contributor III

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

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...😁

SBN_0-1684935633254.png
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

 

Labels (3)
1 Solution

Accepted Solutions
Sabrina_V
Partner - Creator II
Partner - Creator II

Hello,

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

Sabrina_V_0-1685002285131.png

 

 

View solution in original post

3 Replies
Sabrina_V
Partner - Creator II
Partner - Creator II

Hello,

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

Sabrina_V_0-1685002285131.png

 

 

SBN
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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.

SBN_0-1685473360216.png

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

Kind regards,

SBN