topic Getting the next same value from a field-list in QlikView https://community.qlik.com/t5/QlikView/Getting-the-next-same-value-from-a-field-list/m-p/216987#M70245 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I have a field in a straight Table that holds the type of a Transaction. The are two types: A and K. Each type holds a date which can be the same (meaning that on 16/09/2010 we can can have both A and K) and a ranking (calculated as an expression). To the problem now: what I want is to count how many 'A' there are between two 'K', and use that as an expression in the straight table. Thus I want to find the next same 'K' for example and then count Type substracting it by 2 in order to get the count of 'A' . Can anyone shed some light to my problem??</P><P>Thanks</P></BODY></HTML> Fri, 24 Sep 2010 10:15:12 GMT 2010-09-24T10:15:12Z Getting the next same value from a field-list https://community.qlik.com/t5/QlikView/Getting-the-next-same-value-from-a-field-list/m-p/216987#M70245 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I have a field in a straight Table that holds the type of a Transaction. The are two types: A and K. Each type holds a date which can be the same (meaning that on 16/09/2010 we can can have both A and K) and a ranking (calculated as an expression). To the problem now: what I want is to count how many 'A' there are between two 'K', and use that as an expression in the straight table. Thus I want to find the next same 'K' for example and then count Type substracting it by 2 in order to get the count of 'A' . Can anyone shed some light to my problem??</P><P>Thanks</P></BODY></HTML> Fri, 24 Sep 2010 10:15:12 GMT https://community.qlik.com/t5/QlikView/Getting-the-next-same-value-from-a-field-list/m-p/216987#M70245 2010-09-24T10:15:12Z