Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting the next same value from a field-list

Hi all!

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??

Thanks

0 Replies