Qlik Expressions

[cdao]

I'm trying to figure out why this expression is creating an error:

Count({<monthid = max(monthid), initial_screening_completed -= {""}>} RIN)

specifically the monthid = max(monthid), I can set the monthid to a value, 201907

Count({<monthid = {201907}, initial_screening_completed -= {""}>} RIN) 

Which returns the correctly result but would like to set it to the max value. max(monthid) by itself returns the correct value.

[trdandamudi]

Can you give a try on the below:

Count({<monthid ={"=max(monthid)"}, initial_screening_completed -= {""}>} RIN)

[cdao]

I tried it and it didn't include the filter, it just aggregated the total count sans monthid filter

[trdandamudi]

Can you please share sample data and the output that you are expecting ?

[cdao]

Count({<monthid = max(monthid), initial_screening_completed -= {""}>} RIN)

Expected Result = 2

Sample Data:

monthid	RIN	initial_screening_completed	counted
201907	101	7/1/2019	X
201907	102	7/1/2019	X
201907	103
201906	101
201906	102
201906	104	6/1/2019
201905	101	4/2/2019
201905	102
201905	105	5/1/2019

[trdandamudi]

Please use the below expression and you will get the result as 2:

=Count({<monthid ={"$(=Max(monthid))"}, initial_screening_completed -= {""}>} RIN)

[cdao]

Thanks! That worked perfectly

[trdandamudi]

You are welcome... If you think you got the answer can you please close the thread by selecting as right answer, so that it will be useful for others also.