ORDERING

[gcvb]

Hi, I have a problem with Qlik sense. Please help me to write suitable code in Qlik sense providing the solution to the aforesaid problem as indicated below:

I have sale staffs making sales to differrnt countries. These stafss are degreed regarding to the sales volume between the other staffs that are responsible for the sales of same country. Given that logic, when I select a specific date and a specific staff, I want to see that other 5 consecutive staffs that have more sales volume and also other 5 consecutive staffs that have less sales volume than the choosen specific staff. Also please note that each day should include the sales volume of previous days in a selected range of days cumulatively.

For instance, Michael is one of the sales officers who are responsible for Italy region. Sales volume is accounted quarterly. Suppose that he is on the 13th order according to his cumulative sales volume of the second quarter of the 2025 as of 10th of the June 2025 (e.g. second quarter is the current period starting from 1st of April and not completed yet, untill 30th of June)

Given the fact that scenario, when the date of 10th of June 2025 and Michael are chosen together, I want to see the sales officers who have 8th, 9th, 10th, 11th and 12th order and 14th,15th, 16th, 17th and 18th order according to their sales volume.

Let ‘s say Michael was on the 16th order on 3rd of the June 2025. In this case, when 3rd ofJune and Michael are chosen together for the less, I want to see the sales officers who have 11th, 12th, 13th, 14th, 15th order and 17th, 18th, 19th, 20th, 21st order between the officers who are responsible for Italy region.

[-SW-]

This is an interesting challenge.

Can you provide sample data?

[gcvb]

Thank you for your kind response. Due to the legal information privacy requirements, I am not able to share exact sample data. But I can extend the example scenario with the table at below:

According to the table let’s say on 10th of the June officer M’s cumulative sales is counted 9. As a consequence it has the 4th degree between the officers who are responsible for Milano region. When the date of the 10th June and officer M chosen together, I want to see 5 consecutive officers who made more sales than officer M and also 5 consecutive officers who made less sales than officer M in the Milano region. According to this criteria and given table, when I choose the date of the 10th June and officer M together, I should see officers L,K, J ( since there is no more officers who made more sales than officer M in Milano region. Thera are just 3 lucky officers because M already has 4th degree) Also I should see officers N, O, P, Q, R who made less sales than officer M.

Additional information: officers are grouped depending on country and city regions together rather than just being related to the city region. Also if officer M’s sales volume arrives 15, her responsibility for sales region will be changed from Milano to Rome and she will be responsible for Rome automatically