Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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