Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
jgtdx
Contributor
Contributor

Nested set analysis

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

 

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

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