topic Re: Problem with expression in chart in QlikView

Problem with expression in chart

Thu, 25 Jul 2013 13:58:27 GMT

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

Thu, 25 Jul 2013 14:27:46 GMT

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])

)