Nested set analysis

jgtdx — Tue, 15 Nov 2022 14:42:55 GMT

I am trying to use a nested set analysis to get from the same table a count of rows after the last row that met certain condition.

Aggr(Count({$<[ColumnA]={'Value'},[ColumnB]={'No'},
Date={">=$(=aggr(Max({<[ColumnA]={'Value'},[ColumnB]={'Yes'}>}[Date]),[ColumnB]))"}
>} Date), [ColumnB]))

However, the table only shows values when it is filter on a specific value of Column B. and blank when the table is not filtered

Re: Nested set analysis

BrunPierre — Wed, 16 Nov 2022 18:33:24 GMT

Count(Aggr(Count({$<[ColumnA]={'Value'},[ColumnB]={'No'},
Date={">=$(=aggr(Max({<[ColumnA]={'Value'},[ColumnB]={'Yes'}>}[Date]),[ColumnB]))"}
>} Date), [ColumnB])))

topic Nested set analysis in QlikView

Nested set analysis

Re: Nested set analysis