topic How to write set expression? in QlikView

How to write set expression?

Mon, 01 Jul 2013 13:52:03 GMT

Hi,

How to write set expression for below condition

= count({$<BusinessProcessStatus={"New" and "Accepted" } >}DISTINCT DepartmentGUID)

thanks

omyahamburg — Mon, 01 Jul 2013 13:55:49 GMT

Changing {"New" and "Accepted"} to {'New','Accepted'} should make it work.

Mon, 01 Jul 2013 13:57:06 GMT

count({$<BusinessProcessStatus={'New' , 'Accepted' } >}DISTINCT DepartmentGUID)

Anonymous — Mon, 01 Jul 2013 13:58:21 GMT

Hi,

Try this,

= count({$<BusinessProcessStatus={'New','Accepted'} >}DISTINCT DepartmentGUID)

Anonymous — Mon, 01 Jul 2013 14:05:02 GMT

try this

= count({$<BusinessProcessStatus={"New" } *BusinessProcessStatus={" Accepted" } >}DISTINCT DepartmentGUID)

narender123 — Mon, 01 Jul 2013 14:05:18 GMT

Hi,

Try this.

if(BusinessProcessStatus='New' and BusinessProcessStatus='accepted',

count(DISTINCT DepartmentGUID))

jagan — Mon, 01 Jul 2013 14:26:56 GMT

Hi,

Try this hope it helps you

= Sum(Aggr(If(count({<BusinessProcessStatus={"New", "Accepted" } >}DISTINCT BusinessProcessStatus) = 2, 1, 0)

DepartmentGUID))

Regards,

Jagan.