topic Re: Inter-record count in QlikView

Inter-record count

Thu, 07 Aug 2014 15:11:44 GMT

Hello,

I have a question for a scenario I cannot solve.

I would like to count how many times a record from table 1 went back from status 3 to status 2.

In case of item A for example, this is 3 times.

In case of item B for example, this is 2 times.

Thx in advance for any help!

maxgro — Thu, 07 Aug 2014 16:07:23 GMT

str table chart with expression

len(keepchar(replace('-' & concat([Table 2 - Status], '-', [Table 2 - Date]) & '-', 'Status 2-Status 3-', '@'), '@'))

script

LOAD [Table 1], [Table 2 - Date], [Table 2 - Status]

FROM [http://community.qlik.com/thread/128701] (html, codepage is 1252, embedded labels, table is @1);

Thu, 07 Aug 2014 16:09:29 GMT

Inspiration sometimes comes at the end of the workingday.

I just found out that the Above() function can be used to compare two records.

So far, so good. Now just counting them.

I will try out your solution as well Massimo.

Thanks a lot already for the reaction!

Thu, 07 Aug 2014 16:24:00 GMT

Thank you Massimo.

Nice approach to my problem! Will remember that for the future.