How to display Iteration Value in text object

[shabarish0587]

Hi Friends,

      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 .

[Sue_Macaluso]

@shabarish0587 Are you using QlikView or Sense?  I would like to move this into the correct product forum. Thanks.

[shabarish0587]

Hi Macaluso,

             I am using Qlikview, and i got solution on this. Thank you.

[arnav9821 · Accepted solution]

Perhaps declare your date ranges as variables.

Max(Calendar) as variable1

Addmonths(variable1, -23) as variable2

This way you can use the two variables in the set analysis expressions.

[varshapg]

I think you must have to declare the range of the date as a variable and try it.

Max(Date_calander) as variable2
Addurmonth(variable2, -23) as variable3

You must try this and keep the values as you prefer and try this here.