Iterative counter for Tasks in Qlikview

Anonymous — Thu, 15 Feb 2018 14:29:30 GMT

Hi,

I have a business requirement where i have to create a flag which iterates based on a specific task name and all the following tasks should have the same iterated value for the flag.

ID	Task Name	Flag
1	Creation	0
2	Check	0
3	Creation	0
4	Check	0
5	REVIEW	1
6	Creation	1
7	Check	1
8	Creation	1
9	Check	1
10	Creation	1
11	Check	1
12	REVIEW	2
13	Creation	2
14	Check	2

In the above example, i need the flag to iterate based on the field REVIEW and all other following tasks till the next REVIEW task should have the same Flag value.

Kindly help me in resolving this Problem.

Regards,

Arjun

topic Iterative counter for Tasks in Qlikview in QlikView

Iterative counter for Tasks in Qlikview