How to display Iteration Value in textobject

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: How to display Iteration Value in textobject

Brett_Bleess — Mon, 16 Dec 2019 21:55:15 GMT

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

topic How to display Iteration Value in textobject in QlikView

How to display Iteration Value in textobject

Re: How to display Iteration Value in textobject