Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
)
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])
)