Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_2583
Creator
Creator

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