Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_2583
Contributor III
Contributor III

Measure Logic

Hi, 

I have the following logic of which I need to amended to add in extra criteria, however, I don't know where to add this is. 

I need to to include: Type='TY' within the calculation below, any idea how to do this please?

 

Aggr(RangeSum(Above(Count(Count_Flag), 0, RowNo())),Exp_Group,(months_start,(Numeric,Ascending)))
/
Aggr(count(TOTAL <Exp_Group> Count_Flag),Exp_Group,(months_start,(Numeric,Ascending)))

1 Reply
PradeepK
Creator II
Creator II

You can use set expression..  Count( {<Type={'TY'}>} Count_Flag)

Also look into this article : Set-Analysis-in-the-Aggr-function