topic Convert expression to set analysis in QlikView

Convert expression to set analysis

ajayagraa — Thu, 09 May 2013 09:33:50 GMT

HI All

I am new to qlik view can anyone tell me how can i convert my expression given below to set analysis expression

Count(Distinct if(MonthName=KPIMonth and STATUS='CLOSED', bl_no))

I have used this but not working

Count( Distinct {$<MonthName={'$(KPIMonth)'} ,STATUS={"CLOSED"}>} bl_no)

juleshartley — Fri, 10 May 2013 12:33:10 GMT

Hi,

I assume 'KPIMonth' is a variable? I think it might be that you need another '=' in the monthname bit... try this

Count(distinct

MonthName= {"=$(KPIMonth)"}

,STATUS={"CLOSED"}

}

bl_no

)

Any good?