Problem with expression in chart

[#1]

Hello,

I have a problem with expression in one pie chart. I would like to count employees based on some condition, however below expression is not working.

=count({<[Report week]={$(=Max ([Report week]))}> * <[Report Fiscal Month]=[Current Month]>}[Employee counter])

I am new in QlikView and cannot find the solution so far.

thanks in advance for advice ,

Maria

[#2 · Accepted solution]

If you have defined [Current Month] as a variable = month(today()), you can use it in set analysis as follows:

=count({<[Report week]={$(=Max([Report week]))},[Report Fiscal Month]={$([Current Month])}>[Employee counter])

if [Current Month} is a field name then y0u can use teh following if statement:

count(

if([Report week]=max(Report week) and [Report Fiscal Month]=[Current Month],[Employee counter])

)