topic Custom Counter with switches in QlikView https://community.qlik.com/t5/QlikView/Custom-Counter-with-switches/m-p/83530#M789131 <HTML><HEAD></HEAD><BODY><P>I've got a challenge I can't seem to overcome.&nbsp; I would like to assign to every record the count of records of the same type between a change flag.&nbsp; It might be easier to visualize what I want to do from the attached spreadsheet. </P><P></P><P>The purpose is to be able to evaluate "overcoat %" by the length of time (# of coils) ran in succession of the same coating weight.&nbsp; From a basic standpoint, performance should improve (lower overcoat %) on longer runs of the same coating weight up to the bounds of process and measurement variation.</P><P></P><P>I thought the proper approach would be to:</P><P>1.) create a flag when the coating weight changes (done using Previous())</P><P>2.) then create a custom counter that counts the number of coils as long as the coating_change_flag is 0</P><P>3.) then figure out how to assign the last count of that to all the records of that group?</P><P></P><P>I'm totally stuck!&nbsp; </P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT germanboxers 2020-11-25T16:16:04Z Custom Counter with switches https://community.qlik.com/t5/QlikView/Custom-Counter-with-switches/m-p/83530#M789131 <HTML><HEAD></HEAD><BODY><P>I've got a challenge I can't seem to overcome.&nbsp; I would like to assign to every record the count of records of the same type between a change flag.&nbsp; It might be easier to visualize what I want to do from the attached spreadsheet. </P><P></P><P>The purpose is to be able to evaluate "overcoat %" by the length of time (# of coils) ran in succession of the same coating weight.&nbsp; From a basic standpoint, performance should improve (lower overcoat %) on longer runs of the same coating weight up to the bounds of process and measurement variation.</P><P></P><P>I thought the proper approach would be to:</P><P>1.) create a flag when the coating weight changes (done using Previous())</P><P>2.) then create a custom counter that counts the number of coils as long as the coating_change_flag is 0</P><P>3.) then figure out how to assign the last count of that to all the records of that group?</P><P></P><P>I'm totally stuck!&nbsp; </P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Custom-Counter-with-switches/m-p/83530#M789131 germanboxers 2020-11-25T16:16:04Z