Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ajayagraa
New Contributor

Convert expression to set analysis

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)

3 Replies
kumarnatarajan
Valued Contributor

Re: Convert expression to set analysis

Hi,

Exactly i don't know what you want.Try this one:

vKPIMonth=  Concat(DISTINCT '"'&KPIMonth&'"',',')

Create this to variable then use below Exp

  Ex: Count( Distinct {$<MonthName={$(vKPIMonth)} ,STATUS={"CLOSED"}>} bl_no)

thomas_skariah
Contributor III

Re: Convert expression to set analysis

Hi Jolly,

You can try this code

count({$<MonthName={'$(vKPIMonth)'},STATUS={"CLOSED"}>}DISTINCT  bl_no)

Regards,

Tom

Not applicable

Re: Convert expression to set analysis

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

Community Browser