How to display Iteration Value in textobject

[shabarish0587]

I am facing one issue related to Text object. My issue is, i have columns like Team Name, iteration, Start_Date and end_date and so on. Here i want to display current iteration based on team name selection in text object.

For example:

C   2019.12.1    01-12-2019   14-12-2019
For Team name C for this current iteration is 2019.12.1 because start date is 01-12-2019 and end date is 14-12-2019.

my requirement is if i select team name C it should display 2019.12.1 for this period, and also it should not change if we select any other filters like year, month. it only display current iteration based on team name selection in text object. i am sharing sample excel file. can any one help me on this. Thanks in Advance .

[Brett_Bleess · Accepted solution]

You would need to use Set Analysis in your expression:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

That should get you on the right path with things.

Here is the base Design Blog site URL in case you want to search for further posts:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett