Discussion Board for collaboration related to QlikView App Development.
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!
str table chart with expression
len(keepchar(replace('-' & concat([Table 2 - Status], '-', [Table 2 - Date]) & '-', 'Status 2-Status 3-', '@'), '@'))
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);
View solution in original post
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!
Thank you Massimo.
Nice approach to my problem! Will remember that for the future.