topic Re: start counting from null value in QlikView https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14880#M790111 <HTML><HEAD></HEAD><BODY><P>can't you just add another clause: or isnull(EMPLOYEE_AUS) ?</P></BODY></HTML> Mon, 29 Jan 2018 15:31:03 GMT Ben_P 2018-01-29T15:31:03Z start counting from null value https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14879#M790110 <HTML><HEAD></HEAD><BODY><P>Hi Guys.</P><P>I have a table where absenteeism is counted and the count is reset when the field FLAG_AUS &gt;1.</P><P><IMG alt="Captura.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191706_Captura.PNG" style="height: auto;" /></P><P>but I would like it to restart when in FLUS AUS field it is null.</P><P><IMG alt="Captura.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/191707_Captura.PNG" style="height: auto;" /></P><P></P><P>The current code in the script is as follows.</P><P><IMG alt="Captura.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/191708_Captura.PNG" style="height: auto;" /></P><P></P><P>please help me with this topic.</P><P>Greetings.</P><P>Attached the qvw.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14879#M790110 cristianj23a 2020-11-25T16:16:04Z Re: start counting from null value https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14880#M790111 <HTML><HEAD></HEAD><BODY><P>can't you just add another clause: or isnull(EMPLOYEE_AUS) ?</P></BODY></HTML> Mon, 29 Jan 2018 15:31:03 GMT https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14880#M790111 Ben_P 2018-01-29T15:31:03Z Re: start counting from null value https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14881#M790112 <HTML><HEAD></HEAD><BODY><P>... in the line that you have highlighted with the red arrow</P></BODY></HTML> Mon, 29 Jan 2018 15:49:53 GMT https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14881#M790112 Ben_P 2018-01-29T15:49:53Z Re: start counting from null value https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14882#M790113 <HTML><HEAD></HEAD><BODY><P>I managed to solve the problem.</P><P><IMG alt="Captura.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191855_Captura.PNG" style="height: 259px; width: 620px;" /></P><P></P><P>thanks.</P></BODY></HTML> Tue, 30 Jan 2018 12:48:12 GMT https://community.qlik.com/t5/QlikView/start-counting-from-null-value/m-p/14882#M790113 cristianj23a 2018-01-30T12:48:12Z