Count of consecutive nulls

[charu_jain]

Hello All,

I have 3 years of data divided into months. Each month has count of Job vacancies. There is one more column called Job Title. There are some months with null value which has no Job Vacancy.  I want to create a filter in QlikSense which shows Job Title where there is null value for consecutive 6 months. Please let me know a way to show it. That would be really helpful.

I am pasting below the snippet of how the data looks.

	2021											2022
Job Title	1	2	3	4	5	6	7	8	10	11	12	1	2
Data Engineer	-	-	-	-	-	-	1	2	1	-	1	1
Data Scientist	1	1	-	-	-	1	-	-	-	-	-	-	1